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

249 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
coolths123601(None) 
coolth1139511coolth_
booths115313792boo_ths
cloths115512482clo_ths
colts76633292c_olt_s
coolers93522492coolers
coolies93824962coolies
coolish12312522coolish
cools75632632cool__s
coopts105814582coopt_s
coots75636842coo_t_s
couths115715412c_ouths
moolahs12347382moolahs
ooliths10268322_ooliths
sooths95715592soo_ths
tooths96013802too_ths
acroliths1445113acroliths
azoths18366203azo_ths
bolts76232113_bolt_s
boosts86115013boost_s
booth105522013boo_th_
boots75837973boo_t_s
broths115013923bro_ths
celts75325783c_elt_s
chalahs15289883chalahs
chalehs15268803chalehs
cheths14389823c_heths
cholas114818003chol_as
cholates132414763cholates
cholers124215203cholers
chollas123811353chollas
cholos114716853chol_os
chotts113610993cho_tts
choughs16576633choughs
cloots85113693cloot_s
cloth105817543clo_th_
clothe114712993clo_the
clothes124513813clo_thes
clots75627643clo_t_s
cloughs13517053cloughs
clouts87017203clout_s
coacts105314333coact_s
coalas87418963coal_as
coalers94419353coalers
coals76129603coal__s
coapts104614013coapt_s
coasts85719143coast_s
coatis85122603c_oatis
coats75635003c_oat_s
cobalts1139203cobalt_s
cobles104622883cobl_es
coccoliths1652873coccoliths
cocottes1238313cocottes
codlins104116243codlins
coeloms1139063coeloms
cogitos1037613cogitos
cohorts123411103cohort_s
cohosts12398813cohost_s
coilers93619903coilers
coils75030083coil__s
coitus8511893c_oitus
colas75436773c_ol_as
colbys13407153c_olbys
colds85726973c_ol_ds
coles76055063c_ol_es
coleus86818273c_oleus
colics104219903c_olics
colies84837053c_olies
colins85229043c_olins
colitis92617353colitis
collars93816573collars
collates103019143collates
collets93517903collets
collies94326583collies
collins93419833collins
collops112611753collops
colobus11389373colobus
cologs96517353c_ologs
colones96124433colones
colons86028683c_olons
colonus94413443colonus
colors86622373c_olors
colours95913443colours
cols66553083c_ol__s
colt67158243c_olt__
colter84625093c_olter
colters93522443c_olters
coltish121310933c_oltish
colzas174010513c_olzas
comates114123643comates
cometh134811683cometh_
comets105823583comet_s
compts125216653compt_s
comtes106222813c_omtes
conatus9310463conatus
conchs134714903c_onchs
contes84432913c_ontes
contos84923233c_ontos
cooch124916833coo_ch_
cooches143515833cooches
cooees85621893coo_ees
cooers84324563coo_ers
cooeys114914483coo_eys
coofs105924713coo__fs
cookers134619463cookers
cookeys16478503cookeys
cookies133719273cookies
cookless14258633cookless
cooks115429143coo__ks
cooktop1544043cooktop
cooktops1644063cooktops
cool66940493cool___
coolant9316463coolant
coolants1039943coolants
cooled95224593cool_ed
cooler84824713cool_er
coolest9318643coolest
coolie83821603cool_ie
cooling103422573cooling
coolly114811393cool_ly
coolness1037743coolness
cooly105525423cool__y
coombes133810663coombes
coombs124210193coo_mbs
coons76737283coo__ns
coontie9311423coontie
coonties10513803coonties
coopers114019483coopers
coops96229643coo__ps
coopt95929853coopt__
coopted123710773coopted
coos67456493coo___s
coot67860383coo_t__
cooter85128613coo_ter
cooters94525733cooters
cootie84223093coo_tie
cooties93725733cooties
coplots11511593coplots
copouts11311083copout_s
coprahs14338153coprahs
corollas1039213corollas
cosets85824403coset_s
costs77231143c_ost_s
cotes76347843c_o_tes
cots68054843c_o_t_s
cottas84615573c_ottas
coughs125514543c_oughs
coulees9315513coulees
coulis84018763coul_is
coulter94115603coulter
coulters103614313coulters
counts84618273count_s
courts84216173court_s
couth106122493c_outh_
covets114819643covet_s
cowls106922213cowl__s
coxitis16238463coxitis
coxless1637743coxless
coyotes12410703coyotes
crofts114910593croft_s
croutes94815653croutes
crwths1433433c_rwths
cults75022553c_ult_s
cultus85110733c_ultus
dolts65626313_dolt_s
doolees83711613doolees
doolies83920713doolies
drouths11436483drouths
eoliths10318573eoliths
filths12389783_filths
foolish1339613foolish
fools86824203fool__s
footles103715713footles
foots85528283foo_t_s
fourths13374953fourths
froths125411443fro_ths
goths96513003_go_ths
growths1494423growths
healths13478753healths
holts85627913_holt_s
hookahs17446663hookahs
hoorahs13399613hoorahs
hoots84830253hoo_t_s
jolts125018883_jolt_s
loofahs13364623loofahs
loots55431423loo_t_s
mollahs12328283mollahs
molochs1435223molochs
molts76032093_molt_s
monoliths1445913monoliths
months113812933_months
moolah11409193moolah_
moolas83615593mool_as
mooleys1236863mooleys
mools76027173mool__s
moots75831663moo_t_s
moths106021553_mo_ths
moults84713703moult_s
mouths115214533_mouths
neoliths1144933neoliths
norths96812323_norths
oaths86117313__oaths
oohs75220693_oo__hs
oolites72817843_oolites
oolith93813243_oolith_
oomphs1344723_oomphs
oots46446443_oo_t_s
otoliths11104513otoliths
pooftahs1642363pooftahs
poohs103915713poo__hs
poolers94217423poolers
pools74427703pool__s
poults84613483poult_s
roosts64916323roost_s
rootles73215633rootles
roots55933673roo_t_s
rouths95416823_rouths
rowths12458173_rowths
scoots85315943scoo_t_s
scouths12527893scouths
sloths94911893slo_ths
smolts84411883smolt_s
smooths12216323smooths
sooth85924063soo_th_
soothe94214853soo_the
soothes103917113soo_thes
soots55536213soo_t_s
soths86218633_so_ths
souths95216603_souths
spilths12356023spilths
tilths9459373_tilths
toolers74416503toolers
tools55325243tool__s
tooth88020183too_th_
toothy12529693too_thy
tootles72915603tootles
toots55331873too_t_s
troths95414153tro_ths
trowths1365023trowths
uroliths1154923uroliths
voltes94915583_voltes
volts85421293_volt_s
wealths13365813wealths
woolens10398843woolens
woolers104214023woolers
woolies104117363woolies
wools84421463wool__s
worths127812893_worths
youths124510043_youths

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272496.93619323.4
3Display Results2492490.0803112.5
 (SQL Overall)1786912497.40624127.9
 
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.