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

155 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
dragster103462(None) 
dragsters1134321dragsters
dabster1036702d_abster
diaster82813312dia_ster
drafter11449422dra_fter
dragger10309172drag_ger
draggier11135772draggier
gagster9317632_gagster
raster64731442_ra_ster
arrester839253arrester
aster55434893__a_ster
baster85333593_ba_ster
blaster94017303bla_ster
boaster94616433boa_ster
bragger113810043brag_ger
braggier12136453braggier
brasher124515243bra_sher
brasier94516753bra_sier
brassier103310533brassier
brighter1476663brighter
caster85232573_ca_ster
chaster124718503cha_ster
coaster94219043coa_ster
crafter124111333cra_fter
craggier12116063craggier
cragsmen1344763cragsmen
crasher124616163cra_sher
crasser94114333cra_sser
crater85026643cra__ter
dabsters1137053d_absters
dafter104813343d_a_fter
dagger95017303d_ag_ger
darter75320363d_a_rter
dasher104318983d_a_sher
dater65332313d_a__ter
daughter1344503daughter
daunter83811753d_aunter
daystar1143443d_aystar
deemster1175713deemster
degasser10325813degasser
deluster936903deluster
demister11310223demister
dempster1355773dempster
detester9239683detester
diameter1148053diameter
diastem10318043dia_stem
diasters92913183dia_sters
diester83013683d_iester
digester10258433digester
disaster949943disaster
doomster1135843doomster
dopester1137253dopester
drabber12438593dra_bber
draffier1574323draffier
drafted12439033dra_fted
draftee11379523dra_ftee
drafters12338523dra_fters
draftier1285263draftier
dragee84415603drag__ee
dragees9359483drag_ees
dragged11379563drag_ged
draggers11357393drag_gers
draggle1056103draggle_
draggled1254673draggled
draggles1145963draggles
dragnet91211433drag_net
dragnets10136563dragnets
dragomen1245013dragomen
dragonet10138953dragonet
drags75521113drags___
dragstrip1351533dragstrip
drainer83012843dra_iner
draper94315693dra__per
drastic10310873dra_stic
dratted9358593dra_tted
draughted1543693draughted
draughtier1542443draughtier
drawer104711363dra__wer
drawler11338593dra_wler
drawlier12225253drawlier
dreggier1193553dreggier
dresser83611953dr_esser
dressier956863dressier
drifter11348703dr_ifter
drossier956313drossier
drowsier1284903drowsier
druggier11134833druggier
drugstore1142503drugstore
dumpster1344053dumpster
duster74919723d__uster
easter65027983_ea_ster
eraser64216333era_s_er
fagoter1135883_fagoter
faster94625773_fa_ster
feaster10812983fea_ster
frater94520593fra__ter
fraudster1342113fraudster
gagsters10317083_gagsters
gangster10215773gangster
gaster75027353_ga_ster
grafter114211153gra_fter
granter84117133gra_nter
grasper10389793gra_sper
grassier9349283grassier
grater74625443gra__ter
grister83915413gr_ister
hamster12810423_hamster
irater65218353ira__ter
krater104014313kra__ter
lamster9109913_lamster
laster64830633_la_ster
magister1136283_magister
master84831343_ma_ster
paster85734373_pa_ster
piaster93012883pia_ster
plaister1068013plaister
plaster93318693pla_ster
praiser93413943prais_er
prankster1543183prankster
prater84825353pra__ter
prester93519623pr_ester
rafter94517583_ra_fter
raiser66620103_rais_er
ranter63826823_ra_nter
raser55633413_ra_s_er
rasher95024123_ra_sher
rasper83917333_ra_sper
rasters74629023_ra_sters
rater54943283_ra__ter
ratter64326313_ra_tter
register939553_register
rester63832433_r_ester
righter113212383_righter
roadster935463roadster
roaster74116663_roaster
roister73516203_roister
rooster74415173_rooster
roster64329083_r_oster
rouster73517083_rouster
royster103110533_royster
scamster1235303scamster
seamster1037143seamster
songster935793songster
tapster9299273_tapster
taster64930573_ta_ster
teamster1036293teamster
toaster74414463toa_ster
transfer1138433transfer
trasher104416133tra_sher
truster73114313tr_uster
tryster10369513tr_yster
vaster94521023_va_ster
waister103812383_waister
waster95228943_wa_ster
wrester102812413wr_ester

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.436409841.7
2DLD Change Limit1461621556.71621763.3
3Display Results1551550.0503100.0
 (SQL Overall)1786911557.20224811.3
 
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.