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

87 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
chapatis1512794(None) 
chapati14118021chapati_
chapattis1683611chapattis
chappatis18114011chappatis
chapatti15113872chapatti
chappati17124012chappati_
charpais1536932charpa_is
abatis84317933__abatis
bhaktis1633433bha_ktis
capotes11314643c_apotes
capris10415083c_ap_ris
captain112111063c_aptain
captains121810573c_aptains
captans111612053c_aptans
carates95630613c_arates
carats85929023c_arat_s
chablis14368563cha_blis
chadarim1644603chadarim
chadars1338293chada_rs
chais107530313ch__a_is
chalahs15289883chala_hs
chalazas2245893chalazas
chalazia2245133chalazia
chalets122813473chalet_s
challis124613463cha_llis
chamades16138653chamades
chamois143512193cha_mois
champacas2042963champacas
champacs1934633champa_cs
champaks2134103champa_ks
chanties132615803cha_nties
chants115020393cha_nt_s
chaotic14310043cha_otic
chapeaus1544993chapeaus
chapels14429153chap_els
chapes135421873chap__es
chapiter1536603chapiter
chapiters1635203chapiters
chaplain1546193chaplain
chaplains1645743chaplains
chaplets1556883chaplets
chappie16298653chap_pie
chappies172610093chappies
chaps125326063chap___s
chapt125827643chap_t__
chapter144213853chap_ter
chapters154012133chapters
characid1646863characid
characids1745263characids
characin1547993characin
characins1647593characins
charades141310853charades
charas114223613chara__s
charases131312763charases
charities14312743charities
charpai1436633charpa_i_
charquis2243933charquis
chartist131112133cha_rtist
charts115823093cha_rt_s
chassis123910663cha_ssis
chastise1348173cha_stise
chats105730093ch__at_s
chaunts1267083chaunt_s
chayotes1636503chayotes
chazanim24123513chazanim
chazans21268123chaza_ns
cheats114519543ch_eat_s
chelates132713843chelates
chiantis1346593chiantis
cholates132414763cholates
clematis1248653clematis
coapts104614013coap_t_s
coatis85122603c__oatis
colpitis1247503colpitis
cowpats1437713cowpat_s
cravats1237403cravat_s
cyanates13238433cyanates
hamates122917683_hamates
hapaxes1936593_hapaxes
haptic13511893_hap_tic
havartis1444373_havartis
hepatic141712773_hepatic
hepatics15198933_hepatics
khanates1535733khanates
shantis103313103sha_ntis
thanatos1165123thanatos
wapitis1236473_wapitis

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.406440125.6
2DLD Change Limit146162876.86021306.4
3Display Results87870.0302900.0
 (SQL Overall)178691877.29624491.6
 
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.