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 “uplander” 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.

159 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
uplander114554(None) 
uplanders1234861uplanders
auslander1043882auslander
bilander1136672bilander
blander103715172_blander
colander1139032colander
inlander937222inlander
islander946102islander
lander74028492__lander
outlander1045732outlander
pander93725532_p_ander
planer84122662_plan_er
planner93511632_planner
planter94017812_planter
plunder103810512_plunder
slander84015452_slander
solander948122solander
uitlander1042962uitlander
upland938862upland__
uplands1036942upland_s
applauder1442363applauder
auslanders1143363auslanders
balancer1246603balancer
bander93928223__bander
bilanders1235963bilanders
bladder11429153_bladder
blader93618583_bla_der
blanker134612023_blanker
blender104613853_blender
blinder103912993_blinder
blonder104011953_blonder
blunder103813163_blunder
brander103915823_brander
calender1138273calender
clanger104113493_clanger
colanders1238013colanders
cullender1243553cullender
cylinder1433383cylinder
dander811222993__dander
demander12238723demander
expander18145803expander
flanger113412623_flanger
flanker143911293_flanker
flinder11319883_flinder
gander84322763__gander
gladder10398313_gladder
glancer103710073_glancer
glanders103811513_glanders
glandes95413833_glandes
grander93315873_grander
hander104526433__hander
husbander1563153husbander
implanter1385363implanter
inlanders1036143inlanders
islanded1035513islanded
islanders1035283islanders
ladder84617623__ladder
lader65633723__la_der
lancer84319973__lancer
landed84619243__landed
landers84026223__landers
landler84113203__landler
lanker104123003__lanker
lanner64920603__lanner
larder73720973__larder
lauder73815013__lauder
launder8309153__launder
lender73921283__lender
lowlander1342993lowlander
malanders1237023malanders
meander1049973_meander
oleander936403oleander
outlanders1144273outlanders
padder103415493_p_adder
panders103423743_p_anders
panier84425503_p_anier
panner84224763_p_anner
panzer174213233_p_anzer
philander1544063philander
pinder94523463_p_inder
placer105117743_pla_cer
plaguer10328273_plaguer
plaided11409643_plaided
plainer93811983_plainer
plaiter93615393_plaiter
planar84212713_plan_ar
plane74929143_plan_e_
planed94420913_plan_ed
planers94517953_plan_ers
planes85028083_plan_es
planet84228353_plan_et
planked143512283_planked
plankter1435363_plankter
planned103810153_planned
planners10399943_planners
plantar9369993_plantar
planted103516123_planted
planters102915333_planters
plasher124215033_plasher
plaster93318693_plaster
plater84427693_pla_ter
platier93716293_platier
platter93917413_platter
player115215213_pla_yer
pleader103511763_pleader
plinker134010973_plinker
plodder1146013_plodder
plunders11329843_plunders
plunger104211253_plunger
plunker133910663_plunker
pomander1347083pomander
ponder94521703_p_onder
pounder103314013_pounder
prancer113613383_prancer
relanded102410463relanded
relaunder1053703relaunder
sander74828533__sander
slanders94014023_slanders
slender83413603_slender
solanders1036963solanders
spader94317133sp_a_der
spandex1735833sp_andex
spanker133612353sp_anker
spanner94312563sp_anner
spender103713693sp_ender
splasher1335663splasher
splatter10348883splatter
splendor1143753splendor
splinter10329703splinter
squander1835533squander
stander84316163_stander
strander97112063strander
supplanter14113673supplanter
uitlanders1142833uitlanders
unbanded123010563unbanded
under64624223u___nder
unhanded132910183unhanded
unhandier1344883unhandier
unkinder1335363unkinder
unlade72714153unla_de_
unladed92614373unla_ded
unladen8248653unla_den
unlades82612833unla_des
unloader936643unloader
unplanned1244413unplanned
unplanted1236853unplanted
unwinder1235613unwinder
upbraider1442573upbraider
updater10347253upda_ter
upended11267323up_ended
upgather14152753upgather
upholder1444083upholder
uplifter1363903uplifter
uplinked15254203uplinked
uploaded1234533uploaded
upraiser10175843upraiser
urbaner9177133urban_er
wander104423713__wander
zander163417113__zander

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621597.28020077.2
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.76623009.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.