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
doomsters123616(None) 
doomster1135841doomster_
boosters104013432boo_sters
deemsters1285022deemsters
doomsayers1651762doomsayers
doorsteps1252552doorsteps
dopesters1237282dopesters
hoopsters1445672hoopsters
odometers1247132odometers
roosters83514652roo_sters
biometers1339153biometers
boasters103915653_boasters
bolometers1447373bolometers
bolsters103712443_bolsters
boomers114115913boom__ers
booster94314553boo_ster_
cloisters1137413cloisters
coasters104317303_coasters
commuters15378883commuters
cooters94525713coo__ters
costers94128303_co_sters
dabsters1137053d_absters
deemster1175713deemster_
delusters1035973delusters
demisters1249203demisters
dempsters1435273dempsters
detesters10298303detesters
diameters1247583diameters
diasters92913173d_iasters
diesters92513593d_iesters
digesters11257873digesters
dimeters11411083d_imeters
diopters1137683dio_pters
disasters1039143disasters
dockmasters2053103dockmasters
dolomites1248083dolomite_s
doodlers10338843doo_dlers
doomier103610123doom_ier_
doomsayer1551923doomsayer_
doomsdayers185893doomsdayers
doomsdays1651423doomsdays
doorstep1143103doorste_p
doorstops1243023doorstops
doozers17419293doo__zers
dopester1137253dopester_
dormers104313913dorm__ers
dorsers83516293d_ors_ers
dosers75723633d_o_s_ers
dosimeters1345113dosimeters
dossers84516233d_o_ssers
dossiers9318043d_ossiers
doters74423913d_o__ters
dotters83715973d_o_tters
doubters11257373d_oubters
dousers84817273d_ous_ers
dowsers115013523d_ows_ers
dragsters1134323dragsters
dumpsters1453743dumpsters
durometers1356363durometers
dusters84918353d__usters
footers104618333foo__ters
footsteps1462863footsteps
foresters12312533foresters
fosters104220093_fo_sters
geometers1238183geometers
hamsters13710423_hamsters
hoisters113513473_hoisters
holsters113211933_holsters
hoopster1335543hoopster_
hooters104520463hoo__ters
jokesters2044443jokesters
jousters153210403_jousters
lamsters1099753_lamsters
lobsters10268733_lobsters
looters74419163loo__ters
mobsters12359053_mobsters
molesters1198873molesters
momsers113810843_moms_ers
monoesters1245983monoesters
monometers1449363monometers
monsters103314533_monsters
mooters93818623moo__ters
noosers74913913noo_s_ers
odometer1147413odometer_
oldsters996733_oldsters
orometers11310403orometers
ousters74122773__ousters
oysters103411683__oysters
pollsters1137173pollsters
poofters1336923poo_fters
posters93927993_po_sters
potometers1449043potometers
promoters13310073promoters
prompters1537533prompters
roadsters1035083roadsters
roasters83615913_roasters
roisters83615543_roisters
roomers95416413room__ers
roosers74217873roo_s_ers
rooster74415173roo_ster_
rooters74522933roo__ters
rosters73727533_ro_sters
rousters84315653_rousters
roysters113610523_roysters
scamsters1334983scamsters
seamsters1136323seamsters
songsters1046093songsters
teamsters1135973teamsters
toasters83912703_toasters
tonometers1248113tonometers
tooters73818773too__ters
udometers1245743udometers
vomiters1337203_vomiters
zoolaters1844973zoolaters
zosters163015403_zo_sters

Search took 9 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.1561145455.1
2DLD Change Limit1486411158.01618543.0
3Display Results1151150.0462500.0
 (SQL Overall)1786911158.21821743.9
 
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.