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

250 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
chelated14261048(None) 
cheated134416341che_ated
chelate122914891chelate_
chelates132713841chelates
belated103520012_belated
cerated103922472c_erated
cheater124816962che_ater
chelae113614602chela_e_
chelator1347912chelator
cheliped1635042cheliped
chested133811672che_sted
cholate122114932cholate_
cholates132414762cholates
cleated103417842cle_ated
collated113615062collated
corelated12411822corelated
created104323452cre_ated
cremated133412962cremated
crenated113013912crenated
delated93722872_delated
elated74725822__elated
gelated93615632_gelated
heated104525592_he_ated
related83327572_related
ablated102513443_ablated
acerated113113983acerated
acetated112010683acetated
acierated1238283acierated
aculeated1247713aculeated
acylated1437873acylated
adulated1039753adulated
aerated85322373_aerated
alated75625143__alated
areolated1089713areolated
belaced124112153_belaced
belayed133610083_belayed
belted94020633_bel_ted
berated104422133_berated
bleated104015973ble_ated
canulated12310673canulated
caseated11310713caseated
casemated1446953casemated
catenated1238913catenated
caudated1238063caudated
caveated1439133caveated
ceased94920783c_e_ased
cellared11398793cellared
celled94420323c_el_led
celotex1635023c_elotex
cerate84829463c_erate_
cerates95428253c_erates
chafed154813913ch__afed
chaliced1637043chaliced
chalked17449863chal_ked
chanted134015953ch_anted
chapleted1743963chapleted
chared125423693ch__ared
charted135116853ch_arted
chased125019293ch__ased
chatted133411893ch_atted
chaunted1485603chaunted
chawed155214603ch__awed
cheapen14407623che_apen
cheaper144010583che_aper
cheat105732453che_at__
cheaters133613513che_aters
cheats114519543che_at_s
checked193710023che_cked
checkmated2452543checkmated
chedite1338863chedite_
chedites1438263chedites
cheeked17399663che_eked
cheeped153410593che_eped
cheered133713293che_ered
cheerled14105703cheerled
cheesed133910683che_esed
chefed155010563che__fed
cheffed19335863che_ffed
chela103916803chela___
chelas113817203chela__s
chelating1549353chelating
chelation1439963chelation
chelators1448163chelators
chelipeds1743003chelipeds
cheloid13310833chel_oid
chevalet1658123chevalet
chevied16357483che_vied
chewed154415013che__wed
chicaned1665873chicaned
childbed1742883childbed
chilled133310933chil_led
chuted124611843ch__uted
ciliated11510953ciliated
citrated112712253citrated
clawed125115073c__lawed
clayed125013043c__layed
cleaned103512003cle_aned
cleared103612463cle_ared
cleaved134010483cle_aved
clefted13326753cle_fted
coated94927043c__oated
coedited1237833coedited
coempted1535333coempted
coenacted1445803coenacted
coequated2144823coequated
coheaded1536603cohe_aded
cohobated1744883cohobated
collaged12279963collaged
collared113211143collared
collate92919683collate_
collates103019143collates
colleted113011653colleted
combated1539823combated
conflated1539333conflated
copulated142710483copulated
corelate10516013corelate_
corelates11314863corelates
correlated1346683correlated
crated94827773c__rated
creaked143413233cre_aked
creamed123913713cre_amed
creased104315583cre_ased
create85126383cre_ate_
creates95225203cre_ates
credited1238253credited
cremate113816183cremate_
cremates124216003cremates
crenate93317113crenate_
crenelated1375363crenelated
crenulated1356043crenulated
crested103416533cre_sted
cumulated14237843cumulated
cuneated11310103cuneated
curated104717583c_urated
cuspated1335913cuspated
dealated103213603dealated
debated113916083_debated
deflated133412303deflated
delate73827753_delate_
delates83526283_delates
delayed123310763_delayed
deleted93314903_deleted
derated93623503_derated
dilated93115823_dilated
echeloned1543443echeloned
echinated1546483echinated
elate55335883__elate_
elater64724203__elater
elates65032363__elates
elevated12118293elevated
eluted74915263__eluted
emulated11310793emulated
epilated11310753epilated
escheated1546273esche_ated
ethylated1644643ethylated
fellated1239563fellated
felted103714653_fel_ted
galeated104111573galeated
gelate73421253_gelate_
gelates83219583_gelates
gheraoed1343343gheraoed
halted105019603_hal_ted
hated95734023_h__ated
headed114020473_he_aded
healed105121443_he_aled
heaped124516903_he_aped
hearted113314023_hearted
heater94828303_he_ater
heaved134717863_he_aved
hefted134911423_he_fted
heisted113210653_heisted
helled104024703_hel_led
helloed113512423_helloed
helmed124513693_hel_med
helmeted1435833_helmeted
helped124714153_hel_ped
helved134313703_hel_ved
hented104218753_he_nted
hilted104016043_hil_ted
ideated9310973ide_ated
inflated12410863inflated
isolated9410523isolated
iterated91213823iterated
lated65240673___lated
legated92513983_legated
meated94222403_me_ated
melamed1249633_melamed
melted94219063_mel_ted
negated93413233_negated
ocellated1245453ocellated
operated11512223operated
ovulated1237083ovulated
oxalated1695323oxalated
pelted94617753_pel_ted
phenate12412193phenate_
phenates13611573phenates
phenolated1645243phenolated
phonated1447893phonated
pileated112711133pileated
plated95225773__plated
pleated103816633ple_ated
predated12513273predated
prelate9519693prelate_
prelates10418573prelates
rebated103619703_rebated
redated93120923_redated
reflated123514293reflated
regelated1139723regelated
reheated122415003reheated
relaced103517213_relaced
relate64033633_relate_
relater73723143_relater
relates73731433_relates
relaxed153312523_relaxed
relayed113212753_relayed
remated103522473_remated
replated112817513replated
reslated93517523reslated
seated75131053_se_ated
sedated93714343_sedated
sheafed14388973she_afed
sheared114516003she_ared
sheathed1547223she_athed
sheaved143411633she_aved
sheeted113813043she_eted
shelled113815083shel_led
shelter103214963shel_ter
shelved14379933shel_ved
slated75028313__slated
smelted10399093smel_ted
solated83618023_solated
stellated1046803stellated
sublated11311503sublated
sweated113411543swe_ated
teated74924023_te_ated
theater104014253the_ater
thecate123210023thecate_
threated1259203threated
throated1247923throated
treated83618703tre_ated
ululated947663ululated
unheated121514553unhe_ated
unrelated10310433unrelated
velate93720143_velate_
violated1237883violated
welted103715823_wel_ted
wheaten1336403whe_aten
whelmed16375153whel_med
whelped16355633whel_ped
whetted14256693whe_tted

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 Limit1461622507.12320519.7
3Display Results2502500.1102272.7
 (SQL Overall)1786912507.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.