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

203 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
fierily133902(None) 
aerily93017012_aerily
airily93014822ai_rily
eerily92913562_eerily
ferity122813342f_erity
ferly115517352f_er_ly
fibril1137162fibril_
fibrils1236842fibrils
fiercely1643312fiercely
fierier103511192fierier
fiery114714792fier__y
filmily1535732filmily
firefly1635632firefly
firmly1436662fi_rmly
fishily1637642fishily
furrily1337612furrily
leerily1037632leerily
verily122616052_verily
wirily123310782wi_rily
aerify122810113_aerify
alertly1046793alertly
angrily1137723angrily
beefily1535613beefily
blearily1365953blearily
charily15310283charily
cheerily1655423cheerily
clerisy1246823clerisy
clerkly1643573clerkly
deerfly1443983deerfly
dewily1338343_dewily
dietarily1344453dietarily
dingily1238103dingily
direly10311563di_rely
dirtily1138583dirtily
dizzily1934843dizzily
drearily1236083drearily
drily95816523__drily
faerie93514683faeri_e
faeries104118993faeries
faery116015483faer__y
fairly125610013fair_ly
family143311703f_amily
fancily1538253fancily
fattily13379463fattily
featly123711753f_eatly
febrile1237153febrile
feckly18335963f_eckly
feebly1436653f_eebly
feirie939553feiri_e
feistily1445263feistily
felly114922803f_e_lly
feral85424653f_eral_
ferals94216643f_erals
feria85922713f_eri_a
feriae95618603f_eriae
ferial94621253f_erial
ferias95020393f_erias
ferine96422583f_erine
ferlie92814053f_erlie
ferny115816183f_er_ny
ferry116020803f_er_ry
fertile10311733f_ertile
ferula93011173f_erula
ferule93413203f_erule
fervidly1863313f_ervidly
fetidly1435013f_etidly
feyly14429513f_e_yly
fiberfill1751753fiberfill
fiberize2246143fiberize
fibrilla1364373fibrilla
fibrin1138533fibri_n
fibrins1238633fibrins
fickly18318533fi_ckly
fictile1238023fictile
fiddly14328483fi_ddly
fidelity1544933fidelity
field95015323fie__ld
fierce11348913fier_ce
fiercer12356953fiercer
fieriest112112243fieriest
fifthly1943093fifthly
filly114424903fi__lly
filthily1743663filthily
finally13310103finally
finely123011563fi_nely
fineries112416743fineries
finery124512893finer__y
fireclay1644183fireclay
firelit10310863firelit
firing104021723fi_ring
firrier103410133firrier
firry115713533fi_r_ry
firstly1335643firstly
fissile10269653fissile
fitly115114973fi__tly
fixedly2133903fixedly
fixity19427803fi_xity
flakily1736293flakily
fleecily1644013fleecily
fleetly1336313fleetly
fleshily1744533fleshily
fleshly16346093fleshly
flexibly2342723flexibly
flexile1735073flexile
flimsily1643283flimsily
flintily1434893flintily
floridly1554593floridly
flowerily1842993flowerily
flukily1735213flukily
foamily1546543foamily
foggily1535053foggily
foxily1947253f_oxily
freakily1835003freakily
freckly19124593freckly
freely12310953fre_ely
frenzily2343733frenzily
freshly16286833freshly
friarly13316213friar_ly
friendly1544373friendly
frill84917563f__rill
frilly124111443f__rilly
friskily1834503friskily
frizzily2253143frizzily
fuggily1534963fuggily
funkily1736513funkily
funnily1336373funnily
fussily13267603fussily
fustily133111373fustily
fuzzily2145073fuzzily
giddily1335073giddily
girly94415293gi_r_ly
gorily10612503_gorily
hoarily1338973hoarily
icily101211693_i_cily
ickily1535753_ickily
inertly1038543inertly
jerkily2134623_jerkily
kinkily1335223kinkily
liefly1266363lie_fly
livelily1444103livelily
merely111312583_merely
merrily1238633merrily
micrify1744693micrify
milkily16216553milkily
mirkily16266403mirkily
miserly12329823miser_ly
misrely12319613misrely
mistily122612343mistily
needily1166323needily
nervily1336863_nervily
niftily1335753niftily
nigrify1444133nigrify
nippily1444713nippily
nitrify1335793nitrify
nitril62511533nitril_
nitrile73011373nitrile
nitrils72810703nitrils
oilily93111723oi_lily
overfly16246883overfly
overly122411363over_ly
overply15227653overply
overtly13268983overtly
overwily1736663overwily
peril75425953_peril_
perils84121853_perils
perkily1637803_perkily
pertly115312543_pertly
pithily1567033pithily
puerile9310093puerile
reedily1179603reedily
riskily1436413riskily
ritzily1945143ritzily
scarily12311703scarily
seedily1178583seedily
sexily1638853_sexily
silkily14236963silkily
sillily10209783sillily
sorrily1039833sorrily
sterile7316603sterile
sternly1037853sternly
tearily10311153tearily
termly1138433_termly
tidily102811393ti_dily
tiering8315253tiering
tinily94014433ti_nily
tinnily1047363tinnily
tipsily1236043tipsily
tiredly1136793tiredly
verify153110163_verify
verity123714853_verity
virile9313433vi_rile
vitrify1645003vitrify
warily122915093_warily
waterily1438783waterily
wearily1338783wearily
weedily1476123weedily
weevily1694643weevily
weirdly14274493weirdly
wilily123310763wi_lily
windily1437943windily
wintrily1445373wintrily
wispily1535653wispily
wittily1336173wittily

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.1561145455.1
2DLD Change Limit1340272036.71619956.4
3Display Results2032030.0802537.5
 (SQL Overall)1786912036.95225703.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.