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 “wafers” with Change Limit: [1] [2]

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

164 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
wafers12431614(None) 
waders109120641waders
wafer114417641wafer_
wafery15398691wafery
wafters134112811wafters
wagers105122201wagers
wakers134822491wakers
walers94824461walers
waters95030621waters
wavers125022471wavers
waxers164014301waxers
afars85716512_afars
afters94717072_afters
agers65027852_agers
apers76629132_apers
avers85127312_avers
bakers125323452bakers
balers85626932balers
cabers105023902cabers
cafes106426922cafe_s
cagers95624182cagers
caners84629192caners
capers105428132capers
carers85133952carers
caters85336492caters
cavers115026832cavers
chafers154512722chafers
darers75921872darers
daters74827362daters
defers105116942defers
eagers74523682eagers
eaters65535942eaters
facers115519442facers
faders105117462faders
fakers134219532fakers
farers95924052farers
fifers125414922fifers
gaffers14428712gaffers
gagers84021322gagers
gamers94420822gamers
gapers94520462gapers
gaters74728632gaters
gazers164516292gazers
gofers104711512gofers
hafters134614332hafters
halers94926912halers
haters94930392haters
havers124721482havers
hayers124415942hayers
hazers184615952hazers
infers93615442infers
jagers144415722jagers
japers154616172japers
kafirs13306982kafirs
lacers85225252lacers
laders74927762laders
lagers74826142lagers
lakers105225152lakers
lasers64925702lasers
lavers94526362lavers
layers93921182layers
lifers95617842lifers
loafers10349462loafers
macers105321272macers
makers123921732makers
masers84623452masers
maters85032382maters
mazers173917092mazers
namers84517332namers
oaters65029782oaters
offers12349962offers
pacers105124542pacers
pagers94423252pagers
papers105125322papers
parers85530742parers
paters84935822paters
pavers115021822pavers
pawers114818782pawers
payers114621822payers
racers84725432racers
rafters103715632rafters
rakers104123572rakers
rapers84327182rapers
rasers64526782rasers
raters63936572raters
ravers94628182ravers
razers154919612razers
refers93921082refers
sabers85224732sabers
safer84721812safer_
safes85226722safe_s
sakers104125432sakers
savers93825922savers
sawers94620162sawers
sayers94221592sayers
swagers114211022swagers
swayers13398852swayers
tabers84621572tabers
takers103923742takers
talers64628142talers
tamers84224032tamers
tapers84025812tapers
taters64932192taters
tawers94118602tawers
taxers134015282taxers
twofers1364052twofers
wadders123812442wadders
wader95325362wader_
wades95634142wade_s
waes76048602wa_e_s
wafered14288432wafered
wafflers17306322wafflers
waffs146315472waf_fs
wafter124114612wafter_
wafts116920552waf_ts
wager95925052wager_
wages95330932wage_s
waggers124613082waggers
wailers103916802wailers
wairs86424062wa_irs
waiters104218622waiters
waivers133410052waivers
wakens135012042wakens
waker125526592waker_
wakes126633652wake_s
waler84229262waler_
wales86142832wale_s
walkers143411472walkers
wames106432802wame_s
wanders114221332wanders
wanes85040882wane_s
wankers144514712wankers
wanters104420092wanters
warders113416812warders
wares88250582ware_s
warmers124514292warmers
warners103315562warners
warpers123413582warpers
wars78659802wa__rs
washers134517522washers
wasters104026592wasters
water84733312water_
watery123914492watery
waver115025702waver_
wavery154610052wavery
waves115633922wave_s
waveys15597012waveys
waxer154317482waxer_
waxes155825502waxe_s
weaners104613832weaners
wearers104615902wearers
weavers133714462weavers
webers11310942webers
whalers13529702whalers
wifes114522562wife_s
wifeys15425872wifeys
wipers115416082wipers
wirers94617892wirers
wivers125320802wivers
wolfers13409632wolfers
wooers93712442wooers
woofers133810582woofers
yagers105114532yagers
zaffers22386772zaffers

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511642.56332208.7
3Display Results1641640.0632603.2
 (SQL Overall)1786911642.73665311.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.