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

257 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
crinkles1426917(None) 
crankles143510161crankles
cringles11329471cringles
crinkle13359411crinkle_
crinkled15357151crinkled
wrinkles15296701wrinkles
brickles162810282brickles
brindles113710232brindles
crackles164111272crackles
crankle133610062crankle_
crankled15408152crankled
crimples14308962crimples
cringes103215502crin_ges
cringle103010352cringle_
crinites10612762crinites
crinklier1543842crinklier
crinkliest16104522crinkliest
crinkly16387522crinkl_y
cripples14298402cripples
inkles103515652__inkles
prickles162511102prickles
rankles113114552_rankles
runkles114111942_runkles
sprinkles1534932sprinkles
tinkles113713922_tinkles
trickles143013762trickles
trindles93211692trindles
twinkles1535072twinkles
winkles143412772_winkles
wrinkle14296922wrinkle_
wrinkled16275352wrinkled
ankles104818383__ankles
bindles104016453_bindles
brickle15279933brickle_
bricoles122610303bricoles
bridles104114473bri_dles
brindle104210103brindle_
brindled12407853brindled
brineless1136263brineless
brines85028853brin__es
brinies93317923brin_ies
brinks124616313brink__s
bristles101510433bristles
brittles10178653brittles
cackles153717203c_ackles
candles104422343c_andles
cantles94721413c_antles
carioles10817083cari_oles
caruncles1345013caruncles
chickees19258513chickees
chicles143512503chi_cles
chiles115425303chi__les
chinches18369373chinches
chines115029173chin__es
chinked174011023chink_ed
chinkier17377363chinkier
chinkiest1867023chinkiest
chinks155817573chink__s
chinless1337493chin_less
chinones13510483chinones
chintses1337113chintses
chintzes2235973chintzes
chuckles1936803chuckles
cinches144215773c_inches
cineoles10109403c_ineoles
cines75239683c_in__es
cinques1837333c_inques
circles1139903c_ircles
citoles9312553c_itoles
clickless1743983clickless
clinches153910363clinches
clines84926043clin__es
clinked144011643clink_ed
clinker133811663clink_er
clinkers14339833clinkers
clinks125815063clink__s
cockles153414643c_ockles
coinages11310803coinages
comingles1444723comingles
cornicles1368253cornicles
crackle153611253crackle_
crackled17428863crackled
cradles103114133cr_adles
crakes124921813cr_ak_es
cranches153114543cranches
cranes84330753cran__es
cranked143812843crank_ed
cranker133612793crank_er
crankest1438143crank_est
crankier14339163crankier
crankiest1538823crankiest
crankly16358123crankl_y
crankous1435973crankous
cranks125015313crank__s
crannies10313013crannies
creneled11326893creneled
crenelles1146733crenelles
crenels93711013crenel_s
creoles9913323cr_eoles
cribbled15305803cribbled
cricked164814283crick_ed
cricket154716953crick_et
crickets16418123crickets
crickey18418143crick_ey
cricks144316053crick__s
cries75438403cri___es
crikey15317783cri_k_ey
crimeless1335063crimeless
crimes105521583cri__mes
crimple13408693crimple_
crimpled15366933crimpled
cringe93515483crin_ge_
cringed113312403crin_ged
cringer103514243crin_ger
cringers112511873cringers
crinite9513633crinite_
crinkling16145863crinkling
crinoids1147383crinoids
crinolines1246753crinolines
crinums1135863crin_ums
criollos1043713criollos
cripes105120873cri__pes
cripple13378583cripple_
crippled15336803crippled
crippler14826713crippler
cripplers15314993cripplers
crises84529433cri__ses
crones84729243cron__es
cronies9622513cron_ies
crumbles14329683crumbles
crumples14348813crumples
crunches153711353crunches
crunodes1144973crunodes
cuittles1045903cuittles
dindles93817243_dindles
dingles93818323_dingles
dinkies123716033_dinkies
dribbles13348393dribbles
drinkables1741943drinkables
drinker12349483drink_er
drinkers13277823drinkers
drinks116810713drink__s
drizzles17295293drizzles
dwindles13366023dwindles
eringoes937433eringoes
finales104016013_finales
freckles17126383freckles
fribbles15287713fribbles
frijoles1834373frijoles
fringes113514103frin_ges
frizzles19297283frizzles
grackles15309183grackles
granules939943granules
gribbles13307363gribbles
griddles1145753griddles
grilles83715023gri_lles
grinches1436953grinches
gristles9189203gristles
grizzles17286193grizzles
gruntles9287233gruntles
ingles74420873__ingles
inkle94515833__inkle_
inkless11348713__inkless
jingles153816383_jingles
kindles123614843_kindles
mickles153415003_mickles
mingles103719003_mingles
minkes124618783_mink_es
nickles133713823_nickles
orioles7412993ori_oles
pickles153215443_pickles
pinkies133818263_pinkies
pinkoes135512313_pinkoes
pinoles93418713_pinoles
pintles94118733_pintles
prickle153611013prickle_
prickled17358073prickled
princes113015153prin_ces
prinked143412163prink_ed
prinker133412743prink_er
prinkers143010393prinkers
prinks124315383prink__s
printless1137523printless
rankle103414883_rankle_
rankled123910653_rankled
rankless12268243_rankless
riddles93215023_riddles
riffles133911173_riffles
rifles94217713_ri_fles
riles55343643_ri__les
rilles64725503_ri_lles
rimples113114223_rimples
rindless92510203_rindless
ringlet82818173_ringlet
ringlets92910243_ringlets
rinks94827103_rink__s
rinses64720383_rin_ses
ripples113513293_ripples
riskless1235763_riskless
ruckles133414603_ruckles
rundles83214713_rundles
runkle103611543_runkle_
runkled12399013_runkled
scribbles15184953scribbles
shingles123111113shingles
sickles133417543_sickles
singles83520433_singles
spindles112710353spindles
spinules10249333spinules
sprinkle1434893sprinkle_
sprinkled1633713sprinkled
sprinkler1543573sprinkler
sprinklers1642983sprinklers
stickles142512103stickles
strickles1567813strickles
swindles12319503swindles
swingles12319543swingles
tickles133416853_tickles
tingles83818323_tingles
tinkle103714453_tinkle_
tinkled123910473_tinkled
tinkler113610543_tinkler
tinklers12298183_tinklers
triangles1035753triangles
trickle133613443trickle_
trickled152610433trickled
trifles103814833tri_fles
trikes105419493tri_k_es
trindle83311363trindle_
trindled10388693trindled
trines64132563trin__es
trinket11314813trink_et
trinkets1237143trinkets
trinkums1443413trinkums
triples94616873tri_ples
triskeles1344273triskeles
truckles14319383truckles
trundles9278483trundles
twinkies1535983twinkies
twinkle1464773twinkle_
twinkled1663943twinkled
twinkler1564073twinkler
twinklers1633063twinklers
unwrinkles1741523unwrinkles
urinals7610263urinal_s
urinates8314133urinates
urines64724123urin__es
veinules1135913veinules
windles113518493_windles
winkle133812833_winkle_
winkled15299593_winkled
wintles103414983_wintles
wrangles1237473wrangles
wriggles13286263wriggles
wrinklier1643013wrinklier
wrinkliest1743833wrinkliest
wrinkly17295753wrinkl_y

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 Limit1461622577.29620033.2
3Display Results2572570.1102336.4
 (SQL Overall)1786912577.82622833.0
 
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.