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

155 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
chicanes155937(None) 
chicane1489551chicane_
chicaned1665871chicaned
chicaner1586071chicaner
chicaners1685361chicaners
chicanos1595991chicanos
chicanery19103052chicanery
chicano1496872chican_o
chicas135916472chica__s
chickees19258512chickees
chickens19267432chickens
chicles143512502chic_les
chicness1535592chic_ness
chines115029172chi__nes
chinones13510472chinones
caimans113811783caiman_s
calcanea1276283calcanea
calcanei1265273calcanei
calcaneus1344163calcaneus
calcines12314753calcines
cancans11311873cancan_s
canes75350373___canes
carcanet12316353carcanet
carcanets1347313carcanets
carcases12313093carcases
cascades13128553cascades
cetanes9315133c_etanes
chaconnes1644003chaconnes
chafes145017913ch__afes
chaines124518733ch_aines
chalones13312173chalones
chamades16138653chamades
chances145218093ch__ances
changes134517583ch__anges
changs125215373ch__angs
chants115020393ch__ants
chapes135421873ch__apes
charades141310853charades
charases131312763charases
chares115631803ch__ares
chases115128233ch__ases
chazans21268123chazan_s
chelates132713843chelates
chianti1236613chi_anti
chiantis1346593chi_antis
chias104625523chi_a__s
chiasms14357523chi_asms
chiaus113611313chi_a_us
chiauses1336483chiauses
chica125818263chica___
chicalotes17163563chicalotes
chicaneries1853913chicaneries
chicaning1745163chicaning
chicer134513603chic__er
chicest14209943chic__est
chichier1836023chichier
chichiest1936343chichiest
chichis1737073chic_his
chickadee2163743chickadee
chickadees2272303chickadees
chickaree2074703chickaree
chickarees2163223chickarees
chickee183111553chic_kee
chicken18278983chic_ken
chickened2144623chickened
chickpea2143193chickpea
chickpeas2242953chickpeas
chicks175317593chic__ks
chicle134312543chic_le_
chicories1688763chicories
chicos134614833chic__os
chics123920943chic___s
chides124620473chi__des
chigoes1338353chi_goes
childcares1852453childcares
childes134211273chi_ldes
chiles115425303chi__les
chilies124218303chi_lies
chillies134113483chillies
chillness1455373chillness
chimars144010593chima_rs
chimeres153511313chimeres
chimes134922573chi__mes
chimney1795483chi_mney
chimneys1883643chi_mneys
chinas115119403chi__nas
chinbones1655033chinbones
chinches18369363chinches
chine105231723chi__ne_
chined125620063chi__ned
chinks155817573chi__nks
chinned134810493chi_nned
chinone12510153chinone_
chinos115018693chi__nos
chins105631463chi__n_s
chints115117833chi__nts
chintses1337113chintses
chintzes2235973chintzes
chippies17309753chippies
chirres123812253chi_rres
chitins122713793chitin_s
chitons122611913chiton_s
chitties13310773chitties
chivaree1646363chivaree
chivarees1744383chivarees
chivaries1757433chivaries
chives144317593chi__ves
chivies153412853chi_vies
chivvies1954423chivvies
choiceness1743773choiceness
choices142010613choic__es
cholates132414763cholates
cholines132214493cholines
chopines152711733chopines
chorales133712883chorales
chorines132917253chorines
chuckies1937703chuckies
chuckles1936803chuckles
cicadas1235993c_icadas
cicalas1139303c_icalas
cicale10314503c_icale_
cines75239683c_i__nes
cliches144213743clic_hes
climates12311973climates
climaxes1944613climaxes
clines84926043cli__nes
cocaines121314443c_ocaines
coignes103912153coi_gnes
coinages11310803coinages
colicines13311203colicines
concaves1538913concaves
cowbanes1537423cowbanes
cranes84330753c__ranes
cuisines1049373cuisines
culicines1347013culicines
cupcakes1843713cupcakes
cycases1437533c_ycases
decanes103118913_decanes
epicenes1249253epicenes
hexanes17319463_hexanes
hickies163614743_hickies
icones84616383__icones
inanes62519803__inanes
lianes63819323_li_anes
phytanes1645763phytanes
recanes93222263_recanes
shines95028913shi__nes
shitakes1546113shitakes
silanes72517163_silanes
thanes94918983th__anes
thickens17266413thickens
thickness1844443thickness
tisanes7311853_tisanes
tziganes1853023tziganes
whines125120103whi__nes

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.423422437.4
2DLD Change Limit1461621556.67321903.5
3Display Results1551550.0602583.3
 (SQL Overall)1786911557.15624970.8
 
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.