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

253 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
fancily153825(None) 
fancify1834981fancify
cannily1239262cannily
chancily1845242chancily
dandily12279632dandily
facile112514882fa_cile
family143311702fa_mily
fancied133310602fancied
fancier123412062fancier
fancies124018782fancies
fancy134615482fanc__y
fattily13379462fattily
funkily1736512funkily
funnily1336372funnily
handily143610872handily
lacily11612762la_cily
lankily1437122lankily
mangily1339752mangily
manlily1238742manlily
racily11715172ra_cily
rancidly1444432rancidly
saucily1237912saucily
zanily18310182zan_ily
acidly125211793_a_cidly
acidy117214893_a_cidy
aerily93017013_aerily
airily93014823_airily
anally9513503_anally
ancilla948603_ancilla
angrily1137723_angrily
anil46437433_an_il_
anile54634463_an_ile
anils56326723_an_ils
anticly12410053_anticly
anvil82712603_anvil_
anvils9219713_anvils
archly1437353_archly
artily92814713_artily
baggily1436043baggily
balkily16266693balkily
balmily14216463balmily
banally1249223banally
bawdily1635803bawdily
bonnily1236873bonnily
bouncily1544383bouncily
bunchily1844543bunchily
cagily12411563ca_gily
calcify1735873calcify
campily1638273campily
cancel105316683cancel_
cancels114113313cancels
candidly1545213candidly
cattily123210853cattily
crankily1755623crankily
daffily1735133daffily
daily95922333da__ily
daintily1245523daintily
dancing113611563dancing
dandify15245673dandify
dangly114212263dan_gly
dankly14419463dan_kly
daylily1434983daylily
dingily1238103dingily
easily9313023ea_sily
facia103218463fa_ci_a
faciae112913413fa_ciae
facial113615633fa_cial
facially1637643fa_cially
facials123310743fa_cials
facias113415803fa_cias
facies113921593fa_cies
facilely1644363fa_cilely
facility1638243fa_cility
facing125321573fa_cing
facula112912233fa_cula
faculty1535573fa_culty
fadedly1535453fadedly
faecal11359813faecal_
fail74840243fa__il_
fails85631483fa__ils
faintly1337083faintly
fairly125610013fa_irly
fairy115318283fa__iry
fallibly1644393fallibly
falsely1336013falsely
falsify1643613falsify
falsity1335903falsity
fanciers13358083fanciers
fanciest133612713fanciest
fanciful1643943fanciful
fancifully2152833fancifully
fanciless1444603fanciless
fancying1735353fancying
fanfic1436313fanfi_c
fanfics1535173fanfics
fanfold1485373fanfold
fanion94514323fan_ion
fanlike142610503fanlike
fannies103415643fannies
fanning113615073fanning
fanny114816043fan__ny
fantail10310233fantail_
fantails1139693fantails
fantasy1336153fantasy
fanwise1336633fanwise
fanzine1937123fanzine
farci105919313farci__
farcie114816473farci_e
farcies125317883farcies
farcing133514003farcing
farcy135217093farc__y
fascia1148703fasci_a
fasciae1247523fasciae
fascial1258303fascial
fascias1258413fascias
fascicle1554633fascicle
fascine12510583fascine
fascism1436443fascism
fascist1239213fascist
fatally1339893fatally
fatly115716803fa__tly
fatuity1336043fatuity
faucal11339963faucal_
faucals12326563faucals
faucial1257323faucial
faultily1474523faultily
faunally1445433faunally
feckly18335963f_eckly
fencible1545603fencible
fencing132411133fencing
fickly18318533f_ickly
fierily1339023fierily
filmily1535733filmily
finally13310103finally
finely123011563fin_ely
finicky1943713finicky
fishily1637643fishily
flabbily1843353flabbily
flaccidly2041773flaccidly
flakily1736293flakily
flashily1735473flashily
flauntily1542653flauntily
fleecily1644013fleecily
flintily1434893flintily
flukily1735213flukily
foamily1546543foamily
foggily1535053foggily
fondly13299043fon_dly
forcibly1843863forcibly
foxily1947253f_oxily
francium1545623francium
francize2246853francize
frankly17315633fran_kly
franticly1744013franticly
freckly19124593freckly
frenzily2343733frenzily
fuggily1534963fuggily
funicle12237483funicle
furrily1337613furrily
fussily13267603fussily
fustily133111373fustily
fuzzily2145073fuzzily
gaily95020973ga__ily
gamily123712183ga_mily
gangly113911583gan_gly
gassily1137813gassily
gaudily1236523gaudily
gauzily2034393gauzily
gawkily1834093gawkily
hackly18298733ha_ckly
hammily1736063hammily
happily1745763happily
hardily143310273hardily
hastily133010663hastily
hazily2179063ha_zily
icily101211693__icily
jangly174310603jan_gly
jauntily1834173jauntily
jazzily2533373jazzily
juicily1935493juicily
kinkily1335223kinkily
lancing103314123lancing
lanely93914483lan_ely
lankly13439623lan_kly
lazily1859713la_zily
manciple1445093manciple
manila84518303man_ila
manly105022953man__ly
mazily20610393ma_zily
nancies93516843nancies
nancy105214923nanc__y
nastily103011033nastily
nattily103610323nattily
noily86120993__noily
nonoily1049543nonoily
pacify1667473pa_cify
packly17228333pa_ckly
panicky1833853panicky
panicle11129983panicle
panoply1434713panoply
pantile93918483pantile
patchily1885813patchily
paucity1435823paucity
pawkily1934203pawkily
pencil103712973pencil_
pencils113011773pencils
pricily142710283pricily
punchily1844863punchily
punily11311773pun_ily
rainily10310433rainily
rancid9513863ranci_d
rankly133910453ran_kly
raucity1235853raucity
raunchily1742813raunchily
saltily10310543saltily
sanctify1644493sanctify
sanctity1345593sanctity
sandfly1435643sandfly
sanely93114613san_ely
sanicle91210263sanicle
sanity9316203san_ity
sappily1437163sappily
sassily1038723sassily
savvily1634323savvily
scantily1337583scantily
slangily1235383slangily
snakily1436913snakily
spicily1438653spicily
stanchly1644443stanchly
sunnily1037833sunnily
swankily1833833swankily
tacitly1236223ta_citly
tackily1637503tackily
tangibly1444673tangibly
tangly104413913tan_gly
tantivy1335563tantivy
tardily11269583tardily
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
tawnily1335443tawnily
tinily94014433tin_ily
tinnily1047363tinnily
vanity12311933van_ity
vincibly1843583vincibly
wackily1936053wackily
wanly115118023wan__ly
warily122915093wa_rily
waspily1535513waspily
wavily15219483wa_vily
waxily19218413wa_xily
windily1437943windily
zincify2443913zincify

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.406440125.6
2DLD Change Limit1340272536.09321996.9
3Display Results2532530.0932720.4
 (SQL Overall)1786912536.59227107.3
 
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.