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

115 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
doomsters123617(None) 
doomster1135841doomster_
boosters104013442boo_sters
deemsters1285022deemsters
doomsayers1651762doomsayers
doorsteps1252552doorsteps
dopesters1237282dopesters
hoopsters1445692hoopsters
odometers1247132odometers
roosters83514662roo_sters
biometers1339173biometers
boasters103915663_boasters
bolometers1447383bolometers
bolsters103712453_bolsters
boomers114115913boom__ers
booster94314553boo_ster_
cloisters1137433cloisters
coasters104317333_coasters
commuters15378913commuters
cooters94525723coo__ters
costers94128333_co_sters
dabsters1137053d_absters
deemster1175713deemster_
delusters1035983delusters
demisters1249203demisters
dempsters1435273dempsters
detesters10298303detesters
diameters1247593diameters
diasters92913183d_iasters
diesters92513603d_iesters
digesters11257883digesters
dimeters11411093d_imeters
diopters1137693dio_pters
disasters1039153disasters
dockmasters2053103dockmasters
dolomites1248083dolomite_s
doodlers10338843doo_dlers
doomier103610123doom_ier_
doomsayer1551923doomsayer_
doomsdayers185893doomsdayers
doomsdays1651423doomsdays
doorstep1143103doorste_p
doorstops1243033doorstops
doozers17419293doo__zers
dopester1137253dopester_
dormers104313923dorm__ers
dorsers83516303d_ors_ers
dosers75723633d_o_s_ers
dosimeters1345113dosimeters
dossers84516233d_o_ssers
dossiers9318043d_ossiers
doters74423913d_o__ters
dotters83715973d_o_tters
doubters11257393d_oubters
dousers84817273d_ous_ers
dowsers115013533d_ows_ers
dragsters1134323dragsters
dumpsters1453743dumpsters
durometers1356373durometers
dusters84918363d__usters
footers104618333foo__ters
footsteps1462863footsteps
foresters12312533foresters
fosters104220103_fo_sters
geometers1238193geometers
hamsters13710423_hamsters
hoisters113513483_hoisters
holsters113211943_holsters
hoopster1335543hoopster_
hooters104520473hoo__ters
jokesters2044443jokesters
jousters153210423_jousters
lamsters1099753_lamsters
lobsters10268743_lobsters
looters74419163loo__ters
mobsters12359063_mobsters
molesters1198873molesters
momsers113810843_moms_ers
monoesters1245993monoesters
monometers1449363monometers
monsters103314553_monsters
mooters93818623moo__ters
noosers74913923noo_s_ers
odometer1147413odometer_
oldsters996733_oldsters
orometers11310423orometers
ousters74122793__ousters
oysters103411693__oysters
pollsters1137173pollsters
poofters1336923poo_fters
posters93928013_po_sters
potometers1449063potometers
promoters13310093promoters
prompters1537553prompters
roadsters1035103roadsters
roasters83615933_roasters
roisters83615553_roisters
roomers95416413room__ers
roosers74217873roo_s_ers
rooster74415173roo_ster_
rooters74522933roo__ters
rosters73727543_ro_sters
rousters84315683_rousters
roysters113610533_roysters
scamsters1334993scamsters
seamsters1136333seamsters
songsters1046113songsters
teamsters1135973teamsters
toasters83912723_toasters
tonometers1248113tonometers
tooters73818773too__ters
udometers1245743udometers
vomiters1337203_vomiters
zoolaters1844983zoolaters
zosters163015413_zo_sters

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 Filter1786911486410.466383457.1
2DLD Change Limit1486411157.39320105.6
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.90522604.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.