Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “uplanders” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

126 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
uplanders123485(None) 
uplander1145531uplander_
auslanders1143362auslanders
bilanders1235962bilanders
colanders1238012colanders
glanders103811502_glanders
inlanders1036142inlanders
islanders1035282islanders
landers84026212__landers
malanders1237022malanders
outlanders1144272outlanders
panders103423732_p_anders
planers94517942_plan_ers
planners10399932_planners
planters102915322_planters
plunders11329832_plunders
slanders94014012_slanders
solanders1036962solanders
uitlanders1142832uitlanders
uplands1036942upland__s
applauders1542123applauders
auslander1043883auslander_
balancers1345063balancers
banders104324563__banders
bilander1136673bilander_
bladders12397803_bladders
bladers104214683_bla_ders
blander103715163_blander_
blenders115210993_blenders
blinders113911143_blinders
blunders113911343_blunders
branders114313093_branders
calenders1237403calenders
clangers114312343_clangers
colander1139033colander_
cullenders1343193cullenders
cylinders1543203cylinders
danders93921183__danders
demanders13247573demanders
expanders19125093expanders
flangers123311373_flangers
flankers15349303_flankers
flinders12439263_flinders
ganders93521703__ganders
glancers11408003_glancers
glandes95413833_glande_s
handers114224333__handers
husbanders1652913husbanders
implanters1484153implanters
inlander937223inlander_
islander946103islander_
ladders94115173__ladders
laders74927763__la_ders
lancers93616643__lancers
lander74028483__lander_
landlers94312833__landlers
lanners73618333__lanners
larders83516943__larders
lauders84012893__lauders
launders9358743__launders
lenders84419643__lenders
lowlanders1442693lowlanders
meanders1168833_meanders
oleanders1035573oleanders
outlander1045733outlander_
padders113312873_p_adders
pander93725523_p_ander_
paniers94717333_p_aniers
panners93621273_p_anners
panzers184012013_p_anzers
philanders1644273philanders
pinders103720473_p_inders
placers114515263_pla_cers
plaguers11286503_plaguers
plaiters103512633_plaiters
planer84122653_plan_er_
planes85028083_plan_e_s
planets93914083_plan_ets
plankters1544583_plankters
planless1036813_planless
planner93511623_planner_
planter94017803_planter_
plashers133813453_plashers
plasters103518133_plasters
platers93924093_pla_ters
platters103415283_platters
players124313763_pla_yers
pleaders113210183_pleaders
plinkers14309393_plinkers
plodders1235523_plodders
plunder103810503_plunder_
plungers11379403_plungers
plunkers14328333_plunkers
pomanders1436223pomanders
ponders103618843_p_onders
pounders113113283_pounders
prancers123210333_prancers
relaunders1153103relaunders
sanders84025943__sanders
slander84015443_slander_
solander948123solander_
spaders104214473sp_a_ders
spankers14369863sp_ankers
spanners103710773sp_anners
spenders113211743sp_enders
splashers1445283splashers
splatters11327543splatters
splendors1244013splendors
splinters11277923splinters
squanders1934443squanders
standers93514303_standers
stranders10389933stranders
supplanters15113043supplanters
uitlander1042963uitlander_
unlades82612833unla_de_s
unloaders1044403unloaders
unwinders1343943unwinders
upbraiders1542363upbraiders
updaters11255183upda_ters
upgathers1582533upgathers
upholders1543643upholders
upland938863upland___
uplifters1463283uplifters
upraisers11174423upraisers
wanders114221333__wanders
zanders173015793__zanders

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.1561145455.1
2DLD Change Limit1486411266.25023782.6
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.45227695.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.