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

184 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
chedite133886(None) 
cheddite1543951cheddite
chedites1438261chedites
cerite84724872c_erite
cheddites1643012cheddites
chelate122914892chelate
chemise143211502chemise
coedit9316232coedit_
coedited1237822coedited
coedits10310232coedits
coesite9713622coesite
cordite10315252cordite
credit9315192credit_
credited1238252credited
credits1039972credits
khedive1842502khedive
aedile73716653_aedile
aedine73218393_aedine
arenite71017713arenite
caddice13327733caddice
caddie104316443caddi_e
calcite11413783calcite
cardiae10713703cardiae
caudate10311353caudate
cecity1398153c_ecity
cede74928763c_ed__e
cedi74919273c_edi__
ceding104014803c_eding
cedis84317083c_edi_s
cenote83715843c_enote
cerate84829463c_erate
cerise84822043c_erise
cerites94823433c_erites
cete64934783c_e__te
chaine115119223ch_aine
chaise114916413ch_aise
chalice14311043chalice
chamise143612853chamise
chapiter1536603chapiter
charity15311023charity
chaste114617393ch_aste
chayote1536493chayote
cheapie1437563cheapie
cheat105732453che_at_
cheated134416343che_ated
cheater124816953che_ater
cheats114519543che_ats
cheddar14254733cheddar
cheder125113493ched_er
cheders134512393cheders
cheese113812763che_ese
chefing16359033chefing
chegoe1237273che_goe
chelae113614603che_lae
chelated142610483chelated
chelates132713833chelates
cheliped1635043cheliped
chemic153012093chemi_c
chemics16349573chemics
chemises153211983chemises
chemism16339303chemism
chemist143615003chemist
chemists152710323chemists
chenille1354593chenille
cheque2036663che_que
cherish15310463cherish
chert105232103che_rt_
chertier1387873chertier
cherts115617233che_rts
cherty144612473che_rty
cheshire1644553cheshire
chest104926143che_st_
chested133811673che_sted
chestier1387423chestier
chests114916263che_sts
chesty144610503che_sty
cheth135013823che__th
chevied16357483chevied
chevies153511443chevies
cheviot1546933cheviot
cheviots1643783cheviots
chevre14318313che_vre
chevret153310633chevret
chewier1537583chewier
chewing163911143chewing
chewink19315113chewink
chide115321013ch__ide
chiding143911593chiding
chile105626893ch__ile
chime125322593ch__ime
chine105231723ch__ine
chit96937463ch__it_
chits105424573ch__its
chive135117623ch__ive
chlorite133012843chlorite
choice132010523ch_oice
cholate122114933cholate
choline122915383choline
chondrite1545223chondrite
chopine143512263chopine
chordate1448033chordate
chorine123218363chorine
chromite15310833chromite
chute104316463ch__ute
cite65640343c___ite
cleveite1343823cleveite
codeine103815033codeine
coeditor1145713coeditor
coesites101313093coesites
cohesive1646073cohesive
cordate10315213cordate
cordites11314603cordites
cowrite123612683cowrite
create85126373cre_ate
credible1346023credible
creditor1145893creditor
cremate113816183cremate
crenate93317113crenate
crevice1436153crevice
crinite9513633crinite
crudites1137763crudites
crudity1336043crudity
cuddie104011173cuddi_e
cuprite1159683cuprite
curite85222943c_urite
cyanite122710763cyanite
dite55547553___dite
edile64819493__edile
edit54934863__edit_
edited83913673__edited
edits65819033__edits
elite56230183__elite
endite73817593_endite
eremite9312833eremite
erudite838483erudite
evite85317683__evite
expedite1847263expedite
hadith13312063_hadith
halite93624233_halite
heddle114211163_heddle
hedge105317333_hed_ge
hessite1038993_hessite
ichnite1245983ich_nite
indite73520313_indite
inedita846793inedita
inedited10278993inedited
jadeite1546403jadeite
khedives1942183khedives
lenite6719983_lenite
lyddite1243333lyddite
mediae94217413_mediae
mediate103415213_mediate
pedate93117763_pedate
pelite84323003_pelite
petite84320653_petite
phenate12412193phenate
podite93315353_podite
predate10616893predate
predive13511083predive
recite83625113_recite
redate74124683_redate
rediae74221993_rediae
reedit7617223reedit_
reedited10310083reedited
reedits8511743reedits
resite64128453_resite
schedule1443243schedule
scheelite1444203scheelite
sclerite10410713sclerite
sedate73019803_sedate
sedile73517233_sedile
shedlike1635833shedlike
sheltie10109893sheltie
sienite7312713sienite
syenite1039773syenite
thecate123210023thecate
theine94814923the_ine
thermite1339033thermite
thorite10313443thorite
ulexite1445723ulexite
unedited10249833unedited
verite94323443_verite
white114920303wh__ite
yperite1249893yperite

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.1701051123.5
2DLD Change Limit1340271847.44018014.4
3Display Results1841840.0632920.6
 (SQL Overall)1786911847.67323288.3
 
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.