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

278 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
cholates13241474(None) 
chelates132713831chelates
cholate122114931cholate_
apholates1449682apholates
chelate122914892chelate_
chelated142610482chelated
chlorates142512262chlorates
chocolates1746762chocolates
cholas114817992chola__s
cholines132214482cholines
chorales133712872chorales
chordates1547682chordates
chromates16313092chromates
cohobates1646512cohobates
collates103019132collates
comates114123632c_omates
folates103218452_folates
isolates8613512isolates
phonates13410642phonates
phorates13413042phorates
solates73523852_solates
violates11311182violates
ablates92416903_ablates
accolades1445423accolades
acolytes13168033acolytes
acrylates1446683acrylates
acylates1339743acylates
adulates9311913adulates
alates64833963__alates
anolytes11169203anolytes
apholate13410473apholate_
bolases93315003_bolases
boletes9316063_boletes
borates94823013_borates
bromates12413133bromates
calottes10610083calottes
canulates11312863canulates
carates95630603c_arates
caseates10313703caseates
cates75951873c___ates
caudates11310253caudates
cellmates1347513cellmates
cerates95428233c_erates
chafes145017913ch__afes
chalahs15289883chala_hs
chalazas2245893chalazas
chalets122813473chalet_s
chalices15310813chalices
challies133915633challies
chalones13312173chalones
chamades16138633chamades
chapatis15127923chapatis
chapes135421873ch__apes
charades141310843charades
charases131312753charases
chares115631803ch__ares
chases115128233ch__ases
chats105730093ch__at_s
chayotes1636493chayotes
cheated134416343ch_eated
cheater124816953ch_eater
cheaters133613503ch_eaters
cheats114519543ch_eat_s
chedites1438263chedites
chelae113614603chela_e_
chelas113817203chela__s
chelator1347913chelator
chelators1448153chelators
chicanes1559373chicanes
childes134211273chil_des
chiles115425303chil__es
chilies124218303chil_ies
chillies134113473chillies
chlamys1733783ch_lamys
chlorate133112693chlorate_
chlorites142311963chlorites
chocolate1647403chocolate_
chocolatey2053513chocolatey
choices142010613cho_ices
chokes154917383cho__kes
chola104718033chola___
cholents1337623cholents
choler113717153chol__er
choleras13289023choleras
cholers124215193chol_ers
choline122915383choline_
chollas123811353chol_las
cholos114716853chol__os
chooses125717413cho_oses
chopines152711733chopines
choragus1474293choragus
chorale124313353chorale_
chorals124614103chora_ls
chordate1448033chordate_
chores114828023cho__res
chorines132917253chorines
chorten122811303cho_rten
chortens13308793cho_rtens
chortles133611323chortles
choruses1339983choruses
choses115825123cho__ses
chotts113610983cho__tts
chouses125117813cho_uses
choushes1637623choushes
chowses155611283cho_wses
chromate15312783chromate_
chromites16310963chromites
chutes114615763ch__utes
chyles144813283chyl__es
ciliates10413443ciliates
citrates102315073citrates
clades94920463c__lades
claves115020063c__laves
climates12311963climates
clodpates1444103clodpates
coated94927033c_o_ated
coatee84327213c_o_atee
coatees93816533c_o_atees
coater84329553c_o_ater
coaters93525773c_o_aters
coatis85122593c_o_atis
coats75634993c_o_at_s
coaxes154715633c_o_axes
cognates11311573cognates
cohobate1547013cohobate_
cohobated1744883cohobated
colas75436773c_ola__s
coles76055063c_ol__es
colies84837053c_ol_ies
colitis92617343c_olitis
collages113514233collages
collate92919683collate_
collated113615063collated
collets93517903c_ollets
collies94326583c_ollies
colocates13312853colocates
colones96124423c_olones
colter84625093c_ol_ter
colters93522433c_ol_ters
colts76633293c_ol_t_s
colures9315133c_olures
comakes154413643c_omakes
comate104124843c_omate_
comtes106222813c_o_mtes
conatus9310463c_onatus
conflates14311133conflates
contes84432913c_o_ntes
coolants1039943coolants
coolies93824963cool_ies
coolths1236013cool_ths
copulates132612453copulates
corelates11314853corelates
coronates1110816923coronates
corotates112714283corotates
cotes76347843c_o__tes
cowages13310933c_owages
coyotes12410703c_oyotes
crates85736053c__rates
creates95225173c_reates
cremates124215983cremates
croutes94815643cro_utes
cryolites1446953cryolites
culottes1076293culottes
cumulates13258963cumulates
curates95323823c_urates
cutlases1038033cutlases
cyanates13238423cyanates
cyclases1537133cyclases
dealates92716683dealates
deflates123013943deflates
delates83526283_delates
desolates10311793desolates
dholes104914793dhol__es
dilates83220653_dilates
donates83217223_donates
elates65032363__elates
emulates10312573emulates
enolases8411003enolases
ephorates1459153ephorates
epilates10313503epilates
ethylates1545903ethylates
etiolates949193etiolates
evolutes1156063evolutes
fellates11312753fellates
folate93320393_folate_
foliates11412753_foliates
gallates92815523gallates
gelates83219583_gelates
halites103221193_halites
hamates122917673_hamates
hates86742573_h__ates
hoaxes163611693_ho_axes
holards1148433_holards
holes84748653_hol__es
holies94630033_hol_ies
hollies103420813_hollies
holloes103818193_holloes
holster103512213_holster
holsters113211933_holsters
holts85627913_hol_t_s
homages131011583_homages
hoplites13310543_hoplites
horstes104516113_horstes
humates122813193_humates
ichnolites1544003ichnolites
idolater936863idolater
idolaters1045703idolaters
immolates1346453immolates
inflates11512193inflates
insolates9311273insolates
iodates8312893_iodates
iolites73819483_iolites
isolate7313923isolate_
isolated9410523isolated
khanates1535733khanates
locates93218813_locates
malates93522603_malates
neonates8310063neonates
niobates1037273niobates
notates72817483_notates
oblates91913243_oblates
odonates947743odonates
oleates7417833__oleates
oolites72817843_oolites
orates64328613__orates
ovulates1148523ovulates
oxalates1557063oxalates
ozonates1745963ozonates
palates93624933_palates
phenates13611563phenates
phenolates1546983phenolates
phonate12411813phonate_
phonated1447893phonated
phorate12413363phorate_
plates85432243__plates
prelates10418563prelates
probates12414263probates
prolate9419793prolate_
pronates10418373pronates
prorates10418063prorates
reflates113115653reflates
relates73731423_relates
replates102919263replates
reslates83619493reslates
rhyolites1545033rhyolites
rotates72819773_rotates
scholars1336673schola_rs
schoolmates1853633schoolmates
shoats94117073sho_at_s
shoelaces1445233shoelaces
shotes95321893sho__tes
slates64934063__slates
solaces93116133_solaces
solate64526073_solate_
solated83618023_solated
solutes73515263_solutes
solvates11249673_solvates
spoliates1138543spoliates
stomates10313343stomates
sublates10315003sublates
thionates12106643thionates
tholes94919783thol__es
thoraces13118933thoraces
thoraxes1896353thoraxes
thorites11312393thorites
tolanes74216303_tolanes
toluates8138893_toluates
ululates848433ululates
violate10311553violate_
violated1237883violated
violater1137243violater
violaters1245953violaters
voltes94915583_vol_tes
volutes102710983_volutes
wholes124616773whol__es
zeolites1738383zeolites
zoolater1746093zoolater
zoolaters1844973zoolaters

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.1731032896.0
2DLD Change Limit1461622786.92321112.5
3Display Results2782780.1102527.3
 (SQL Overall)1786912787.20624797.5
 
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.