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

240 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
guitars811686(None) 
guitar7117441guitar_
gaiters83516542gaiters
goiters84014442goiters
guars65021052gu__ars
guiders94111112guiders
guisard954202guisard
guisards1043602guisards
guitarist10157082guitarist
gutters83715512gutters
quintars17337562quintars
sitars65417592_sitars
suiters73618882suiters
suitors73012492suitors
agitas7310593agita_s
altars64518153_altars
antiars7314623antiars
attars64515313_attars
auditors947613auditors
avatars1036443avatars
baiters94619303baiters
biters83925243_biters
briars84814823bri_ars
bruiters10329143bruiters
bunters94717123bunters
bursars94510893bursars
busbars1138153busbars
bustard10389723bustard
bustards11308513bustards
busters94724133busters
buttals938503buttals
butters94521723butters
chimars144010593chimars
cigars9910723_cigars
citers85022983_citers
costars94218013costars
cottars94412243cottars
cuirass934973cuirass
curtals93111623curtals
custard10389973custard
custards11338393custards
cutters94218963cutters
dinars75417563_dinars
ditas65923673_dita_s
duikers12369383duikers
duits65021883duit__s
durbars1077973durbars
dusters84918363dusters
editors839423editors
fiars86720833_fi_ars
friars93812093fri_ars
fruiters11328183fruiters
fulmars1246423fulmars
gainers84214593gainers
gaiter73819503gaiter_
gaits65726013gait__s
gars55750743g___ars
garters84218233garters
gasters85624293gasters
gaters74728643g_aters
gators74115833g_ators
gaydars1235803gaydars
gazars164811553g_azars
gears64628693g__ears
genitals937243genitals
genitors937423genitors
getas65421483g_eta_s
getters84216103getters
gibers95114663g_ibers
gigas75415583g_iga_s
gitano738043g_itano
gitanos837173g_itanos
gites65630183g_it_es
gits55744593g_it__s
givers104817713g_ivers
glias64618493gli_a_s
gliders94811843gliders
glisters93912603glisters
glitters93710543glitters
glitzes17367563glitzes
gnars66718853g__nars
goiter74116203goiter_
goitre7349003goit_re
goitres8389563goitres
graters85419743graters
grifters12389233grifters
gripers104011463gripers
gristers94013403gristers
griths105211653grit_hs
grits65529583grit__s
gritters94210633gritters
grunters9359033grunters
guaiacs1054353guaiacs
guanays1134953guanays
guans64419443gu__ans
guar56923293gu__ar_
guard74415543gu__ard
guards84611573gu__ards
guavas1037163guava_s
guffaws1762273guffaws
guider84313523guider_
guides84118283gui_des
guidons936623guidons
guids75516153gui__ds
guilders1035513guilders
guilds8388353gui_lds
guiles73919283gui_les
guilts74111233gui_lts
guimpes1245073guimpes
guineas836753guineas
guipure1043533guipure
guipures1143733guipures
guiro63712093gui__ro
guiros7389093gui_ros
guises74216313gui_ses
guitarfish1751253guitarfish
guitarists11134653guitarists
gulags837543gu_lags
gular6314833gu_lar_
gulpers10299013gulpers
gummas114810513gumma_s
gummers123712203gummers
gunites8313123gunit_es
gunners83111733gunners
gurnard944773gurnard
gurnards1043633gurnards
gushers113512513gushers
gustoes879873gustoes
gusts65722793gust__s
guts56637253gu_t__s
gutta64613383gutta__
guttae73210583gutta_e
guttate8328903guttate
gutter73817713gutter_
guttery11427763guttery
guttlers9306933guttlers
guttles83011933guttles
hunters103915733hunters
hurters103413643hurters
hussars10326983hussars
igniters9126233igniters
ignitors9135513ignitors
instars7411133instars
izars145112933__izars
juicers1636153juicers
juntas134210503junta_s
justers143815733justers
kantars11310033kantars
kiters105218593_kiters
kulturs1134723kulturs
kurtas10349883kurta_s
liars54723163_li_ars
lidars7310783_lidars
litas54923773_lita_s
liters65429883_liters
loiters74116613loiters
lumbars11289763lumbars
lunars65012813lu_nars
lusters73921443lusters
miters84328783_miters
mortars93411523mortars
muggars11316643muggars
mustard10359533mustard
mustards11297883mustards
musters94522513musters
mutters94117143mutters
nectars938463nectars
niters64624213_niters
nutters74215433nutters
ottars64112223_ottars
ousters74122793ousters
outers64230173ou_ters
outwars10912793outwars
pitas77427673_pita_s
pulsars9358913pulsars
punters93617043punters
puritans1037633puritans
putters94219193putters
qintars16268573qintars
quasars1646903quasars
quieters17248733quieters
quilters17228433quilters
quinary1936933quinary
quintals17288003quintals
quintans17337873quintans
quintar16478603quintar_
quintas163611713quinta_s
quits144122353quit__s
quitters17238523quitters
quittors17155413quittors
quivers19298753quivers
quotas15339433quota_s
quoters16369263quoters
raitas64417673raita_s
ritard74812083_ritard
ritards8439943_ritards
ruiners74213023ruiners
seitans73312303seitans
shikars1436183shikars
simars84916933_simars
simitars1046483simitars
sitar54820543_sitar_
sizars154812623_sizars
smiters93414363smiters
spitals93011593spitals
stars55836573__stars
sugars7312423su_gars
suiter64121813suiter_
suites63727403suit_es
suitor63311053suitor_
suits55028053suit__s
sultans72411833sultans
suntans72111733suntans
sutras64818593su_tras
suttas63813793sutta_s
tars46763953___tars
tartars73313403tartars
tatars64619793_tatars
titans63414913_titans
titers64526413_titers
tuatara745513tuatara
tuataras844863tuataras
tufters10298353tufters
tussars7359253tussars
tutors6912333tu_tors
ultras6310193_ultras
unbars82113033_unbars
unitard838003unitard
unitards945623unitards
unitary1038613unitary
uniters73814173uniters
uptears9106453_uptears
utas45924953_u_ta_s
utters63817123_utters
vicars11712263_vicars
vitals94514303_vitals
vulgars11306533vulgars
waiters104218623waiters
witans93412933_witans
writers105513493writers

Search took 7 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 Filter1786911340270.420425454.8
2DLD Change Limit1340272405.73623365.9
3Display Results2402400.0932580.6
 (SQL Overall)1786912406.24928595.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.