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

108 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
pomanders143622(None) 
pomander1347081pomander_
colanders1238012colanders
commanders17146682commanders
demanders13247572demanders
panders103423742p__anders
pomades123711732poma_de_s
ponders103618852po__nders
pounders113113292po_unders
romancers1345732romancers
solanders1036962solanders
amenders11288353_amenders
banders104324563__banders
bilanders1235963bilanders
boarders11408623bo_arders
bombarders17153203bombarders
bonders104120663bo__nders
bounders114314123bo_unders
branders114313093_branders
colander1139033colander_
comakers16339173coma_kers
comanagers1543833comanagers
commandeers18123183commandeers
commander16127403commander_
commandery20134253commandery
commenders17137143commenders
corianders1344913corianders
danders93921183__danders
demander12238723demander_
domineers1244673domineers
emenders11319033_emenders
expanders19125093expanders
fomenters1437853fomenters
founders123911683fo_unders
ganders93521703__ganders
geomancers1542953geomancers
germanders1444603germanders
glanders103811513_glanders
goosanders1242863goosanders
handers114224333__handers
hoarders12307433ho_arders
homagers1486833homa_gers
hounders123111723ho_unders
inlanders1036143inlanders
islanders1035283islanders
joinders16337203jo_inders
komondors1642353komondors
landers84026223__landers
loaders83413433lo_a_ders
loaners73913623lo_an_ers
lowlanders1442693lowlanders
madders113513213__madders
malanders1237023malanders
mangers103521263__mangers
manners93417833__manners
maunders11348353__maunders
meanders1168833_meanders
menders103818803__menders
minders103720123__minders
moaners92813553mo_an_ers
oleanders1035573oleanders
padders113312873p__adders
pander93725533p__ander_
paniers94717333p__aniers
panners93621273p__anners
panzers184012013p__anzers
paraders113113123para_ders
philanders1644273philanders
pinders103720483p__inders
planers94517953p_lan_ers
planners10399943p_lanners
planters102915333p_lanters
pleaders113210193plea_ders
plunders11329843p_lunders
poachers152910763po_achers
pointers103013723po_inters
polders103617373po__lders
pomaces132712123poma_ce_s
pomade113611333poma_de__
pomaded13377863poma_de_d
ponder94521703po__nder_
pouncers12349213po_uncers
pounder103314013po_under_
powders134111553po__wders
prancers123210343p_rancers
profaners14256213profan_ers
promenaders16102583promenaders
provenders1644273provenders
remainders1354023remainders
reminders12308653reminders
romancer1247293romancer_
romances12310793romance_s
rounders92613703ro_unders
sanders84025943__sanders
slanders94014023_slanders
solander948123solander_
sonders83820713so__nders
sounders93214123so_unders
squanders1934443squanders
standers93514303_standers
stranders10389943stranders
uplanders1234863uplanders
wanders114221333__wanders
womanizers2444173womanizers
womanless1443383womanless
womanness1444473womanness
wonders113315993wo__nders
zanders173015793__zanders

Search took 9 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.420425454.8
2DLD Change Limit1486411087.56319653.7
3Display Results1081080.0462347.8
 (SQL Overall)1786911088.02922255.7
 
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.