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 “chaetaf” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
chaeta11310681chaeta_
chaetae1238601chaetae
chaetal1238281chaetal
chateau1236272chateau
cheetah1545452cheetah
chetah14399582ch_etah
bhakta1533653bhakta_
bhaktas1633643bhaktas
caeca93915133c_aeca_
caecal103713733c_aecal
caesar8410933c_aesar
caftan111710123c_aftan
cantal84122033c_antal
captan101613343c_aptan
chacma1537903chacma_
chacmas1638003chacmas
chadar1239353cha_dar
chaebol1444943chaebol
chaff165016283cha__ff
chakra15437533chakra_
chakras16428503chakras
chalah143511663cha_lah
chalet113825993chalet__
chalets122813473chalet_s
challa114014193challa_
challah15458323challah
challas124414123challas
champac1834953champac
champak2034493champak
chant105932693chant__
chantage1446633chantage
chanted134015953chanted
chanter123919733chanter
chantey154112543chantey
chantor123710313chantor
chantry15388223chantry
chants115020393chant_s
chanty145215823chant_y
chaotic14310043chaotic
chapati14118023chapati
chapeau1435523chapeau
chapman1637893chapman
chapt125827643chapt__
chapter144213853chapter
chaqueta2242753chaqueta_
chaquetas2342193chaquetas
charas114223613cha_ras
charka154011703charka_
charkas164810963charkas
charpai1436633charpai
chart105038283chart__
charted135116853charted
charter123918303charter
charts115823093chart_s
chasmal14158213chasmal
chaste114617393chast_e
chasten124312403chasten
chaster124718503chaster
chat95546133cha_t__
chateaus1346013chateaus
chateaux2043073chateaux
chats105730093cha_t_s
chatted133411893chatted
chattel12388893chattel
chatter124416643chatter
chatty14419363cha_tty
chazan20269133cha_zan
chazzan20204853chazzan
cheap126915943ch_e_ap
cheat105732453ch_e_at
cheated134416343cheated
cheater124816963cheater
cheats114519543cheat_s
cheetahs1643783cheetahs
chef125125623ch_e__f
chela103916803ch_ela_
chelae113614603ch_elae
chelas113817203ch_elas
chetahs15347073ch_etahs
cheth135013823ch_et_h
cheths14389823ch_eths
chief134419483chie__f
chigetai1443233chigetai
chital114313883ch_ital
coaeval1245183coaeval
coastal9411043coastal
haaf106227733_ha__af
haemal113811643_haemal
haet75659503_haet__
haets86525123_haet_s
hartal9415473_hartal
hyetal1236543_hyetal
phaeton1235973phaeton
shaitan1036893shaitan
sheaf115424123sh_e_af
theta83414573th_eta_
thetas93011573th_etas

Search took 10 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.406440125.6
2DLD Change Limit134027978.75015317.4
3Display Results97970.0631539.7
 (SQL Overall)178691979.21919382.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.