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

181 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
ficklest1726790(None) 
micklest16219121micklest
dickiest153412502dickiest
feckless17225782feckless
fickle153912972fickle__
fickler16348422fickle_r
ickiest133611042_ickiest
kickiest13319672kickiest
mickles153415002mickles_
nickles133713822nickles_
pickiest162712592pickiest
pickles153215442pickles_
sickest131813792sick_est
sickles133417542sickles_
sickliest1547522sickliest
tickles133416852tickles_
wickless1736082wickless
backless162910633backless
backlist16910653backlist
backrest1639393backrest
brickiest1737433brickiest
brickles162810283brickles_
buckles153416093buckles_
cackles153717203cackles_
clickless1743983clickless
cockiest163013293cockiest
cockles153414643cockles_
deckles143312803deckles_
diciest103316523dic_iest
dickies143416343dickies_
dictiest113212783dictiest
dinkiest133812873dinkiest
duckiest153211863duckiest
faceless13269173faceless
feculent1346953feculent
feeblest1336913feeblest
fellest10313753f_ellest
fices106031163fic__es_
fiches145219533fic_hes_
fickleness1943663fickleness
fickly18318533fickl__y
ficoes114613463fic_oes_
ficuses12159203ficuses_
fiddles123212603fiddles_
fiercest13216143fiercest
fieriest112112243fieriest
files85441273fi__les_
filet85540163fi__le_t
filets94718953fi__lets
filles94224523fi_lles_
fillet95027083fi_lle_t
fillets103414753fi_llets
filmiest1338553filmiest
filmless1344553filmless
fimbles143510663fimbles_
finales104016013finales_
finalist113014733finalist
finest94321733fi__nest
finickiest1942693finickiest
finless102810783fi_nless
finniest113011403finniest
fipples14298653fipples_
fireless112810593fireless
firmest1239273fi_rmest
firriest112310433firriest
fiscalist1446573fiscalist
fishiest14310453fishiest
fishless1436413fishless
fittest102510803fi_ttest
fizziest19226073fizziest
fizzles18339063fizzles_
flakiest153210543flakiest
fleckless1842893fleckless
flockiest1835643flockiest
flockless1843163flockless
flukiest15248063flukiest
folkiest15319503folkiest
forkiest153812303forkiest
forkless15267433forkless
foulest10313313f_oulest
frailest1139493frailest
freckles17126383freckles_
freckliest1943383freckliest
friskiest1636233friskiest
frockless1843453frockless
fullest10313343f_ullest
funkiest152810973funkiest
hackles162917063hackles_
hackliest1836523hackliest
heckles163711383heckles_
hickies163614743hickies_
hinkiest153311753hinkiest
huckles163612623huckles_
iceless9219963_iceless
iciest82914743_ic_iest
idlest74014863_i_dlest
illest63615723_i_llest
inkiest113415043_inkiest
inkles103515653_inkles_
inkless11348713_inkless
keckles12318763keckles_
kinkiest113110503kinkiest
kittlest12297573kittlest
likest104914383li_k_est
littlest8309243littlest
luckiest143011443luckiest
luckless14265893luckless
mackles154415753mackles_
mickle143715133mickle__
mickler153310233mickle_r
milkiest142911083milkiest
milkless1434773milkless
mirkest13309723mirk_est
mirkiest142910253mirkiest
muckiest163210913muckiest
muckles153413253muckles_
neckless14236433neckless
nicest82315663nic__est
nickels13338653nickels_
nickle123814483nickle__
nickled144010443nickle_d
nimblest1236923nimblest
peckiest162711393peckiest
picket144924313pick_e_t
pickets154314183pick_ets
pickle144215653pickle__
pickled164011883pickle_d
pinkest132812623pink_est
pockiest163412053pockiest
prickiest1748183prickiest
prickles162511093prickles_
prickliest1845293prickliest
quickest2345343quick_est
reckless14257973reckless
richest122813683ric_hest
rickets134915093rick_ets
riskiest12310133riskiest
riskless1235763riskless
rockiest142912223rockiest
rockless14297293rockless
ruckles133414603ruckles_
sickees134514213sickees_
sickies133717503sickies_
sickle124418323sickle__
sickled144713433sickle_d
sicklies14710013sicklies_
sickness1437833sickness
silkiest123212853silkiest
simplest122310223simplest
slickest14229253slick_est
sockless14267793sockless
stickiest15229603stickiest
stickles142512103stickles_
suckiest143314113suckiest
suckles134516743suckles_
suckless14288823suckless
tackiest143112433tackiest
tackles133816523tackles_
tackless14419483tackless
thickest17337303thick_est
ticket124524853tick_e_t
tickets134113683tick_ets
tickle124616743tickle__
tickled144313133tickle_d
tickler133612653tickle_r
ticklers14339303ticklers
ticklish1755283ticklish
tinkles113713923tinkles_
tinkliest1336133tinkliest
trickiest1549023trickiest
trickles143013763trickles_
trickliest1646433trickliest
viceless1337983viceless
vilest9416843vi__lest
wackest164710863wack_est
wackiest172610273wackiest
wickedest1943463wickedest
wicket155318943wick_e_t
wickets164010943wick_ets
winkles143412773winkles_
yuckiest17328833yuckiest

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.440406115.9
2DLD Change Limit1461621817.47019566.5
3Display Results1811810.0762381.6
 (SQL Overall)1786911817.98622375.5
 
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.