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

173 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
chichier183602(None) 
chinchier1944631chinchier
catchier15329862catchier
chicaner1586072chicaner
chicer134513602chic__er
chichi1637092chichi__
chichiest1936342chichiest
chichis1737072chichi_s
chillier13328422chillier
chinkier17377362chinkier
chippier17297672chippier
chirpier15276302chirpier
churchier1944152churchier
achier113914263__achier
beachier1538803beachier
beechier1535633beechier
bitchier15307733bitchier
botchier15287143botchier
brickier16307163brickier
bunchier1536153bunchier
cahier113615773c__ahier
cashier123713323c_ashier
catcher143115823catch_er
chaffier1935473chaffier
chalkier1736753chalkier
chancier1538823chancier
charier124317903ch_arier
charrier1378683charrier
chattier1337513chattier
checker18329533chec_ker
cheekier1735103cheekier
cheerier1348003cheerier
cheesier1335963cheesier
chertier1387873chertier
cheshire1644553cheshire
chestier1387423chestier
chewier1537593ch_ewier
chicane1489553chicane_
chicaned1665873chicaned
chicaners1685363chicaners
chicanery19103053chicanery
chicanes1559373chicanes
chickee183111553chic_kee
chickees19258513chickees
chicken18278983chic_ken
chickpea2143193chickpea
chicle134312543chic_le_
chicles143512503chic_les
chicories1688763chicories
chider125116053chi__der
chiefer1536863chi_efer
chigger1436003chi_gger
childlier1543093childlier
chilies124218303chi_lies
chiller124112183chi_ller
chillies134113483chillies
chimer135517203chi__mer
chinches18369363chinch_es
chinchiest2044413chinchiest
chintzier2342663chintzier
chipper163912583chi_pper
chippie16297693chippie_
chippies17309753chippies
chirker16429323chi_rker
chirper14359963chi_rper
chiseler1335903chiseler
chitter124112963chi_tter
chitties13310773chitties
chivied16368383chi_vied
chivies153412853chi_vies
chivvied2052523chivvied
chivvies1954423chivvies
choicer14197893choic__er
chokier1638043ch_okier
choosier1337173choosier
choppier17286643choppier
chromier1538033chromier
chubbier1733893chubbier
chuckies1937703chuckies
chuckler1935553chuckler
chuffier1934543chuffier
chummier1734513chummier
chunkier17395883chunkier
churchlier2052263churchlier
cipher133710263c_iph_er
cither114616683c_ith_er
cliche133712453clich_e_
cliched153711023clich_ed
cliches144213743clich_es
clicker154111883clic_ker
cliffier1633913cliffier
clincher15347663clinch_er
clingier1155853clingier
cliquier1944223cliquier
clothier1335363clothier
coacher143714123coach_er
cockier154013623c_ockier
colickier1743513colickier
conchie143312683conchie_
conchies153214853conchies
coucher144515853couch_er
couthier13218913couthier
crimpier14287323crimpier
crispier12297253crispier
crunchier1644683crunchier
cushier123610833c_ushier
dicier94416233_dic_ier
dickier143512453_dickier
dictier103411863_dictier
dishier113613403_dishier
fishier13359853_fishier
flichter1664963flichter
glitchier1542793glitchier
hickie153812473_hickie_
hickies163614743_hickies
higher134610893_high_er
hillier103413963_hillier
hinkier143610793_hinkier
hippier143212103_hippier
hissier103410503_hissier
hitcher153712003_hitch_er
hither124417253_hith_er
icier74313753__ic_ier
ickier12439923__ickier
itchier12247673_itchier
juicier1635463juic_ier
kickier12349053_kickier
leachier1337253leachier
patchier15319663patchier
peachier1548623peachier
pickier153912973_pickier
pitchier15368273pitchier
pithier123010293_pithier
poachier1556823poachier
pouchier1546803pouchier
pricier113313113pric_ier
prickier16368143prickier
punchier1536413punchier
reechier1336673reechier
richer114015043_rich_er
schizier2234063schi_zier
schizzier2242253schizzier
shicker163914823shic_ker
shiftier1436343shiftier
shinier104113143shi_nier
shirtier1137943shirtier
shittier1137313shittier
shtickier1843163shtickier
spicier115112463spic_ier
stickier14229763stickier
swishier1434563swishier
techier1269243_techier
tetchier1336453tetchier
thatchier1743983thatchier
thicker163611023thic_ker
thither13328103thith_er
torchier1337463torchier
touchier1347383touchier
trickier143010233trickier
twitchier1753233twitchier
vichies15310623_vichies
whackier2044673whackier
whichever2341903whichever
whicker19359773whic_ker
whinier134110633whi_nier
whinnier14255003whinnier
whippier18265823whippier
whirlier14175293whirlier
whither163510253whith_er
whitier133311063whi_tier
whizzier2233283whizzier
witchier16307883witchier
withier132910493_withier

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.420425454.8
2DLD Change Limit1461621736.75021653.6
3Display Results1731730.0632746.0
 (SQL Overall)1786911737.23324705.0
 
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.