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

170 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
chicane148955(None) 
chicaned1665871chicaned
chicaner1586071chicaner
chicanes1559371chicanes
chicano1496871chicano
chica125818262chica__
chicaners1685362chicaners
chicanery19103052chicanery
chicanos1595992chicanos
chicas135916472chica_s
chickee183111552chickee
chicken18278982chicken
chicle134312542chic_le
chine105231722chi__ne
chinone12510162chinone
cicale10314502c_icale
arcane81216743_arcane
caiman103615673caiman_
caimans113811783caimans
calcanea1276293calcanea
calcanei1265273calcanei
calcine11315273calcine
cancan10314103cancan_
cancans11311873cancans
cane66653123___cane
carcanet12316353carcanet
carcase11312743carcase
cascade12118603cascade
cetane8315283c_etane
chaconne1543933chaconne
chafe135117353ch__afe
chaine115119223ch_aine
chalone12312103chalone
chamade15138453chamade
chance134617093ch__ance
chang115418563ch__ang
change124116753ch__ange
chant105932693ch__ant
chape125221143ch__ape
charade13129913charade
chare105231983ch__are
chase105127123ch__ase
chazan20269133chazan_
chazans21268123chazans
chelae113614613chela_e
chelate122914903chelate
chia96026623chi_a__
chianti1236613chi_anti
chiao105618363chi_a_o
chias104625523chi_a_s
chiasm13449103chi_asm
chiaus113611313chi_aus
chic115925203chic___
chicalote16123813chicalote
chicaning1745163chicaning
chicer134513603chic_er
chicest14209943chicest
chichi1637093chic_hi
chichier1836023chichier
chichis1737073chichis
chick165419133chic__k
chickadee2163743chickadee
chickaree2074713chickaree
chickees19258513chickees
chickened2144623chickened
chickens19267433chickens
chickpea2143203chickpea
chicks175317593chic_ks
chicles143512503chicles
chicly16429203chic_ly
chicness1535593chic_ness
chico124218253chic__o
chicory1735993chicory
chicos134614833chic_os
chics123920943chic__s
chidden14255223chidden
chide115321023chi__de
chiding143911593chiding
chigoe1237533chi_goe
childcare1742763childcare
childe124711213chi_lde
chile105626893chi__le
chimar133911473chima_r
chimars144010593chimars
chime125322593chi__me
chimere144010633chimere
chiming153311833chiming
chimney1795483chi_mney
chin96934743chi__n_
china105022483chi__na
chinas115119403china_s
chinbone1555163chinbone
chined125620063chi__ned
chines115029173chi__nes
chining133316843chining
chink145321593chi__nk
chinned134810503chi_nned
chino105823313chi__no
chinones13510483chinones
chins105631463chi__ns
chippie16297693chippie
chiral114614413chira_l
chirre114111853chi_rre
chirren12388743chirren
chital114313883chita_l
chitin113114963chitin_
chitins122713793chitins
chiton112612393chiton_
chitons122611913chitons
chivaree1646373chivaree
chivari1536043chivari
chive135117623chi__ve
choana1138443ch_oana
choanae1236863ch_oanae
choice132010523choic__e
cholate122114933cholate
choline122915383choline
chopine143512263chopine
chorale124313353chorale
chorine123218363chorine
chuckle1836443chuckle
cicada1136413c_icada
cicadae1244853c_icadae
cicala10310063c_icala
cine66242953c_i__ne
cliche133712453clic_he
climate11312833climate
cline76428533cli__ne
cnidae978143cnida_e
cocaine111315173c_ocaine
coigne94612193coi_gne
coinage10310553coinage
colicine12312993colicine
concave1439373concave
cowbane1437673cowbane
crane75331603c__rane
crimine112413473crimine
crocine11314153crocine
cuisine9310423cuisine
culicine1248343culicine
cupcake1743953cupcake
decane93818873_decane
echidnae1442903echidnae
echinate1359403echinate
epicene1148593epicene
hexane16379533_hexane
hickie153812473_hickie
hircine1239143_hircine
humane112812173_humane
inane52820343__inane
liane54720663_li_ane
phocine1438833phocine
phytane1545443phytane
picante11310523_picante
plicae10410953plica_e
plicate11314513plicate
recane83022873_recane
shine85533093shi__ne
shitake1455623shitake
silane62718053_silane
spicae104313703spica_e
spicate113214193spicate
thane86122533th__ane
thecae11299653theca_e
thecate123210023thecate
thicken16317873thicken
thine85026863thi__ne
tisane6311573_tisane
tzigane1742943tzigane
whine116022813whi__ne

Search took 7 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.453394461.4
2DLD Change Limit1340271706.44020811.6
3Display Results1701700.0602833.3
 (SQL Overall)1786911706.95325699.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.