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

112 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
chapati1411800(None) 
chapatis15127921chapatis
chapatti15113861chapatti
chappati17124001chappati
chapattis1683602chapattis
chappatis18114002chappatis
chapt125827642chap_t_
charpai1436622charpa_i
agapai9456843agapa_i
bhakti1544323bha_kti
cacti9318633c_a_cti
calami10313423c_alami
calathi1247573c_alathi
capita102913773c_apita
capote10315733c_apote
captain112111053c_aptain
captan101613343c_aptan
caput9823973c_aput_
carat75048793c_arat_
carate84734003c_arate
carats85929023c_arats
chadar1239343chada_r
chadarim1644573chadarim
chadars1338273chadars
chadri1238133cha_dri
chaeta11310683cha_eta
chaetae1238603chaetae
chaetal1238283chaetal
chai95929903ch__a_i
chalah143511653chala_h
chalahs15289883chalahs
chalaza2145733chalaza
chalazia2245113chalazia
chalet113825993chalet_
chalets122813473chalets
chalot113020133chalot_
chaloth15298603chaloth
chalutz2195083chalutz
chamade15138433chamade
champac1834953champa_c
champaca1943203champaca
champacs1934623champacs
champak2034493champa_k
champaks2134093champaks
chant105932693cha_nt_
chants115020393cha_nts
chanty145215823cha_nty
chaotic14310013cha_otic
chap114928493chap___
chape125221143chap__e
chapeau1435523chapeau
chapeaus1544973chapeaus
chapeaux2242523chapeaux
chapel134911373chap_el
chapels14429153chapels
chapes135421873chap_es
chapiter1536603chapiter
chaplain1546193chaplain
chaplet14512253chaplet
chaplets1556883chaplets
chapman1637893chapman
chapmen1637283chapmen
chapped172711443chapped
chappie16298653chappie
chaps125326063chap__s
chapter144213853chapter
characid1646843characid
characin1547973characin
charade13129903charade
charas114223593chara_s
charity15311023charity
charpais1536923charpais
charqui2143993charqui
chart105038283cha_rt_
charts115823093cha_rts
chaste114617393cha_ste
chat95546133ch__at_
chats105730093ch__ats
chatty14419363cha_tty
chaunt11613493chaunt_
chaunts1267083chaunts
chayote1536493chayote
chazan20269133chaza_n
chazanim24123493chazanim
chazans21268123chazans
cheat105732453ch_eat_
cheats114519543ch_eats
chelate122914893chelate
chianti1236603chianti
chivari1536033chivari
cholate122114933cholate
choragi1346683choragi
clapt98027173clap_t_
clavate1238713clavate
coapt96131523coap_t_
coapts104614003coap_ts
coati75624633c__oati
cowpat13312033cowpat_
cowpats1437713cowpats
cravat11314443cravat_
cravats1237393cravats
cuspate1138233cuspate
cyanate12259703cyanate
hamate113319823_hamate
hapax1739323_hapa_x
haptic13511883_hap_tic
havarti1345053_havarti
hepatic141712773_hepatic
khanate1437073khanate
shanti94014073sha_nti
thalami1246063thalami
wapiti1138363_wapiti

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.1561145455.1
2DLD Change Limit1340271126.96619240.2
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.16824929.0
 
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.