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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

77 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
dumpsters145374(None) 
dempsters1435271dempsters
dumpster1344051dumpster_
demisters1249202demisters
dempster1355772dempster_
dumpers123412662dump__ers
dumpsites1443762dumpsite_s
dusters84918362du__sters
quipsters2043592quipsters
sumpters1238022sump_ters
bimesters1336343bimesters
bumpers133912053bump__ers
bursters1038983bu_rsters
busters94724133bu__sters
composters16388323composters
computers15339753computers
dabsters1137053d_absters
dampeners1444663dampeners
dampers123915693damp__ers
deemsters1285023deemsters
delusters1035983delusters
demister11310223demister_
detesters10298303detesters
diasters92913183d_iasters
diesters92513603d_iesters
digesters11257883digesters
dimeters11411093dim_eters
diopters1137693diop_ters
disasters1039153disasters
disputers1236613disputers
doomsters1236173doomsters
dopesters1237283dopesters
dragsters1134323dragsters
dumper114615213dump__er_
dumpier12409653dump_ier_
dumpiness1435653dumpiness
dumpsite1344293dumpsite__
dupers94615603du_p__ers
duster74919723du__ster_
gamesters1236733gamesters
gypsters1434023_gypsters
hamsters13710423ham_sters
hipsters13268793_hipsters
hoopsters1445693hoopsters
hucksters1843653hucksters
humpers142713523hump__ers
imposters13347343_imposters
imputers1235823_imputers
jumpers18399843jump__ers
justers143815733ju__sters
lamisters1157123lamisters
lamsters1099753lam_sters
lumpers113514483lump__ers
lusters73921443lu__sters
masters94628923__masters
misters93927513__misters
muensters1143253muensters
mumpers133311373mump__ers
munsters104010553mu_nsters
musters94522513__musters
ousters74122793ou__sters
outmasters1245733outmasters
pumpers133113673pump__ers
punsters103310583pu_nsters
questers17168763qu_esters
quipster1933933quipster_
remasters11310583remasters
rimesters1137483rimesters
semesters1139123semesters
sumpter1138873sump_ter_
tapsters10318803_tapsters
tempters12257293temp_ters
tipsters10278513_tipsters
trumpeters1442633trumpeters
ulsters72711983_u_lsters
upsteps1133743_u_psteps
upstirs935293_u_pstirs

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.423422437.4
2DLD Change Limit148641776.48322927.8
3Display Results77770.0302566.7
 (SQL Overall)178691776.93625762.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.