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

90 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
dumpster134405(None) 
dempster1355771dempster
dumpsters1453741dumpsters
demister11310222demister
dempsters1435272dempsters
dumper114615212dump__er
dumpier12409652dump_ier
dumpsite1344292dumpsite_
dumpsites1443762dumpsites
duster74919722du__ster
quipster1933932quipster
sumpter1138872sump_ter
auguster943953auguster
bimester1236163bimester
bumper123714343bump__er
bumpier13359203bump_ier
burster9310293bu_rster
buster84726493bu__ster
composter15369563composter
computer144511513computer
dabster1036703d_abster
dampener1335533dampener
damper114117753damp__er
deemster1175713deemster
deluster936903deluster
demasted1238763demasted
demisters1249203demisters
detester9239683detester
diaster82813313d_iaster
diester83013683d_iester
digester10258433digester
dimeter10411893dim_eter
dimplier1336673dimplier
diopter1038473diop_ter
disaster949943disaster
disputer1137973disputer
doomster1135843doomster
dopester1137253dopester
dragster1034623dragster
dumber114414173dum__ber
dumped123814493dump__ed
dumpers123412663dump__ers
dumps105220103dumps___
duper85519003du_p__er
dusted83918373du__sted
dusters84918363du__sters
dustier83814133du__stier
gamester1137323gamester
gypster1333953_gypster
hamster12810423ham_ster
hipster12288783_hipster
hoopster1335543hoopster
huckster1743823huckster
humper134115883hump__er
humpier143110723hump_ier
imposter12288163_imposter
imputer1136533_imputer
jumper173612373jump__er
jumpier18317943jump_ier
juster134617013ju__ster
lamister1037653lamister
lamster9109913lam_ster
limpsier1234433limpsier
lumper103816653lump__er
lumpier113410143lump_ier
luster64023673lu__ster
master84831343__master
mister84728563__mister
muenster1043313muenster
mumper123513523mump__er
munster93710523mu_nster
muster84724523__muster
ouster64223733ou__ster
outmaster1147303outmaster
pumper124415553pump__er
punster92911103pu_nster
quester161410023qu_ester
quipsters2043593quipsters
remaster10311473remaster
rimester1037813rimester
rumplier1235303rumplier
semester1038903semester
sumpters1238023sump_ters
tapster9299273_tapster
tempter11358213temp_ter
tipster9299053_tipster
trumpeter1343153trumpeter
ulster63712103_u_lster
upstep1035503_u_pstep
upstir835383_u_pstir

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.500357382.0
2DLD Change Limit146162907.32619951.1
3Display Results90900.0461956.5
 (SQL Overall)178691907.87222699.6
 
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.