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

131 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
doomster113584(None) 
doomsters1236171doomsters
booster94314552boo_ster
deemster1175712deemster
doomier103610122doom_ier
doomsayer1551922doomsayer
doorstep1143102doorstep
dopester1137252dopester
hoopster1335542hoopster
odometer1147412odometer
rooster74415172roo_ster
biometer1239603biometer
boaster94616433_boaster
bolometer1348213bolometer
bolster93713423_bolster
boomer104618513boom__er
boomier113312183boom_ier
boosted104111983boo_sted
boosters104013443boo_sters
cloister1037093cloister
coaster94219043_coaster
commuter143010153commuter
cooter85128613coo__ter
coster84331293_co_ster
dabster1036703d_abster
deemsters1285023deemsters
deluster936903deluster
demister11310223demister
dempster1355773dempster
detester9239683detester
diameter1148053diameter
diaster82813313d_iaster
diester83013683d_iester
digester10258433digester
dimeter10411893d_imeter
diopter1038473dio_pter
disaster949943disaster
dockmaster1963073dockmaster
dolomite1148133dolomite_
dolomites1248083dolomites
doodler93310153doo_dler
doomed104113293doom__ed
dooms85321343dooms___
doomsayers1651763doomsayers
doomsday1542003doomsday
doomsdayer175943doomsdayer
doorsteps1252553doorsteps
doorstop1143113doorstop
doozer163910463doo__zer
dopesters1237283dopesters
dormer94415903dorm__er
dorser74819183d_ors_er
doser66228563d_o_s_er
dosimeter1245363dosimeter
dosser74417973d_o_sser
dossier83711693d_ossier
doter65428623d_o__ter
dotter74419343d_o_tter
doubter10298353d_oubter
douser75621633d_ous_er
dowser104716083d_ows_er
dragster1034623dragster
drossier956313drossier
drowsier1284903drowsier
dumpster1344053dumpster
durometer1246443durometer
duster74919723d__uster
footer94320773foo__ter
footstep1363823footstep
forester11313673forester
foster94322223_fo_ster
geometer1138423geometer
goosier83512563goo_sier
hamster12810423_hamster
hoister103714203_hoister
holster103512213_holster
honester1139713honester
hoopsters1445693hoopsters
hooter94123933hoo__ter
jokester1934443jokester
jouster143311043_jouster
lamster9109913_lamster
lobster9288853_lobster
looser65219943loo_s_er
looter64222323loo__ter
mobster11299213_mobster
modester1197483modester
moister94015373_moister
molester1099373molester
momser104011413_moms_er
monoester1146453monoester
monometer1349933monometer
monster93214603_monster
mooter83921093moo__ter
nooser65517823noo_s_er
odometers1247133odometers
oldster896573_oldster
orometer10310703orometer
ouster64223733__ouster
oyster94111703__oyster
pollster1037103pollster
poofter1237163poo_fter
poster84129173_po_ster
potometer1349843potometer
promoter12311453promoter
prompter1437983prompter
roadster935463roadster
roaster74116663_roaster
robuster1035663robuster
roister73516203_roister
roomer84718633room__er
roomier93812243room_ier
rooser63921883roo_s_er
roosted83211883roo_sted
roosters83514663roo_sters
rooter64926033roo__ter
roster64329083_ro_ster
rouster73517083_rouster
royster103110533_royster
scamster1235303scamster
seamster1037143seamster
songster935793songster
teamster1036293teamster
toaster74414463_toaster
tonometer1148293tonometer
tooter64420803too__ter
udometer1146333udometer
vomiter1237953_vomiter
woodsier1245473woodsier
zoolater1746093zoolater
zoster153715853_zo_ster

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.423422437.4
2DLD Change Limit1461621317.07620656.0
3Display Results1311310.0632079.4
 (SQL Overall)1786911317.56223630.1
 
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.