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

123 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
pomander134708(None) 
pomanders1436221pomanders
colander1139032colander
commander16127402commander
demander12238722demander
pander93725522p__ander
pomade113611332poma_de_
pomaded13377862poma_ded
pomades123711732poma_des
ponder94521692po__nder
pounder103314002po_under
romancer1247292romancer
solander948122solander
amender10349613_amender
bander93928223__bander
bilander1136673bilander
blander103715163_blander
boarder103910323bo_arder
bombarder16143583bombarder
bonder95324783bo__nder
bounder104215533bo_under
brander103915823_brander
colanders1238013colanders
comade114415323coma_de_
comaker153410603coma_ker
comanager1444533comanager
commanded17136503commanded
commandeer17124113commandeer
commanders17146683commanders
commandery20134253commandery
commender16167923commender
coriander1245663coriander
dander811222993__dander
demanded13348513demanded
demanders13247573demanders
domineer1146273domineer
emender10649843_emender
expander18145803expander
fomenter1339263fomenter
fonder104120063fo__nder
founder114312573fo_under
gander84322763__gander
geomancer1443753geomancer
germander1345363germander
goosander1143253goosander
grander93315873_grander
hander104526433__hander
hoarder11329233ho_arder
homager13107853homa_ger
hounder113412233ho_under
humaner12257663human_er
inlander937223inlander
islander946103islander
joinder15337593jo_inder
komondor1541883komondor
lander74028483__lander
loader74316313lo_a_der
loaner64416503lo_an_er
lowlander1342993lowlander
madder103515593__madder
manger94325003__manger
manner84020513__manner
maunder10328683__maunder
meander1049973_meander
mender93520793__mender
minder94822503__minder
moaner84415113mo_an_er
normande1145943normande_
oleander936403oleander
padder103415493p__adder
panders103423733p__anders
panier84425503p__anier
panner84224763p__anner
panzer174213233p__anzer
parader103914863para_der
philander1544063philander
pinder94523453p__inder
planer84122653p_lan_er
planner93511623p_lanner
planter94017803p_lanter
pleader103511753plea_der
plunder103810503p_lunder
poacher143912323po_acher
poinded11358973po_inded
pointer93814933po_inter
polder94019253po__lder
pomace123111913poma_ce_
pomaces132712123poma_ces
ponded105218773po__nded
ponders103618843po__nders
pornier93413133po_rnier
pouncer113511233po_uncer
pounded114112793po_unded
pounders113113283po_unders
powder123611903po__wder
prancer113613383p_rancer
profaner13197943profan_er
promenader1583493promenader
provender1544893provender
remainder1244683remainder
remanded123011323remanded
reminder113110513reminder
romance11311083romance_
romanced1337253romanced
romancers1345733romancers
romances12310793romances
rounder83514603ro_under
sander74828533__sander
slander84015443_slander
solanders1036963solanders
sonder73623523so__nder
sounder83315383so_under
squander1835533squander
stander84316163_stander
strander97112063strander
uplander1145533uplander
wander104423713__wander
womaned1337213woman_ed
womanizer2346243womanizer
womanlier1443323womanlier
wonder103617813wo__nder
yonder103214133yo__nder
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.420425454.8
2DLD Change Limit1461621237.45319611.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.91922564.8
 
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.