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

236 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
faintly133708(None) 
saintly1039341saintly
auntly95211062_auntly
daintily1245522daintily
dainty105311472daint_y
faint85837062faint__
fainted114211722fainted
fainter103611052fainter
faints94818782faint_s
fairly125610012fai_rly
fatly115716802fa__tly
finely123011562f_inely
fitly115114972f_i_tly
flintily1434892flintily
flinty126112492flint_y
gainly1049322gain_ly
gauntly1135332gauntly
jointly1735482jointly
mainly11411492main_ly
painty114714752paint_y
quaintly2065022quaintly
rainily10310432rainily
riantly1037612riantly
vainly1258502vain_ly
affinely1743863affinely
airily93014823_airily
antsy85712793_a_ntsy
aptly105111813_a_ptly
aunty85919813_aunt_y
bairnly1234503bairnly
banty106624003ba_nt_y
blindly1335743blindly
bluntly1235223bluntly
brainily1337313brainily
bristly12178063bristly
brittly12165973brittly
cannily1239263cannily
cantle84522153ca_ntle
canty105226803ca_nt_y
chintzy24364223chintzy
crinkly16387523crinkly
daftly1335443da_ftly
daily95922333dai__ly
dangly114212273da_ngly
dankly14419463da_nkly
daringly1348573daringly
defiantly1644153defiantly
dinkly144311083_dinkly
facetely1643853facetely
facially1637643facially
facilely1644363facilely
faculty1535573faculty
fadedly1535453fadedly
fail74840243fai__l_
failingly1636133failingly
faille93414743fai_lle
fails85631483fai__ls
fain75840563fain___
fainer94717243fain_er
fainest10417703fainest
fainters11349693fainters
faintest1139073faintest
fainting123312163fainting
faintish1446193faintish
fairway1644333fairway
fairy115318283fai__ry
faith115620853fai_t_h
faiths124610273fai_ths
falsely1336013falsely
family143311703fa_mily
fancily1538253fancily
fancy134615483fa_n_cy
fanny114816043fa_n_ny
fantasy1336153fa_ntasy
fantod102010033fa_ntod
fantom112110803fa_ntom
fatally1339893fatally
fattily13379463fattily
fatty115117413fa__tty
faultily1474523faultily
faulty12429363fault_y
faunal94711593faunal_
faunally1445433faunally
fawningly1944053fawningly
fawny144711713fawn__y
featly123711753f_eatly
feint84732253feint__
feinted11379623feinted
feints94813873feint_s
feistily1445263feistily
feisty12449293feist_y
felinely1445953felinely
fickly18318533f_ickly
fiddly14328483f_iddly
fifthly1943093f_ifthly
fifty145211423f_ift_y
filly114424903f_i_lly
filthy15356423f_ilthy
final83922033f_inal_
finale94116763f_inale
finally13310103f_inally
finals94316163f_inals
finery124512893f_inery
finitely1445663f_initely
finny114716753f_in_ny
firmly1436663f_irmly
firstly1335643firstly
flamingly1845033flamingly
flaringly1646263flaringly
flatly123110213f_latly
flauntily1542653flauntily
flaunty1354413flaunt_y
fleetly1336323fleetly
flint87333503flint__
flinted114411893flinted
flints95617453flint_s
flirty12499143flirt_y
fluently1445133fluently
fondly13299043f_ondly
frailly1337313frai_lly
frailty1335663frailt_y
frankly17315633frankly
friarly13316213friarly
friendly1544383friendly
frilly124111443fri_lly
fringy13309263frin_gy
frizzly21455793frizzly
fumingly1735743fumingly
funnily1336373funnily
gaiety10119373gaiet_y
gaily95020973gai__ly
gainsay1144043gainsay
gangly113911593ga_ngly
gantry103810113ga_ntry
gapingly1536183gapingly
gauntry1154113gauntry
gently103710913_gently
glinty106910693glint_y
gristly11187333gristly
haint85436323haint__
haints94417583haint_s
hantle94318203ha_ntle
inly75622213__in_ly
jangly174310613ja_ngly
janty156816963ja_nt_y
japingly2135763japingly
jauntily1834173jauntily
jaunty16388513jaunt_y
jingly174111933_jingly
kindly14358853_kindly
kingly143511303_kingly
lairdly1134913lairdly
laithly1335653laithly
laity85318903lai_t_y
lanely93914483la_nely
lankly13439623la_nkly
lastly93310873la_stly
latently1146353latently
linty87126563_lint_y
lyingly14115263lyingly
mainstay1344033mainstay
maintop1135143maintop
manly105022953ma_n_ly
mantle84420923ma_ntle
minty106323903_mint_y
moistly1236613moistly
naively1335903naively
natantly1144293natantly
ninthly1344213_ninthly
paint75443693paint__
painted104214633painted
painter93814563painter
painterly1443313painterly
paints85921833paint_s
pantry115014103pa_ntry
panty105929303pa_nt_y
partly116315473pa_rtly
patently1347113patently
patiently1445633patiently
patly105020583pa__tly
pinkly155012243_pinkly
pintle83818263_pintle
plainly1236473plain_ly
pliantly1345783pliantly
pointy114913283point_y
quietly1945893quietly
radiantly1344993radiantly
ragingly1337863ragingly
rainy85921083rain__y
rankly133910453ra_nkly
raptly11338913ra_ptly
rattly94111543ra_ttly
ravingly1537293ravingly
saint55147073saint__
sainted84114243sainted
saints65122423saint_s
saliently1245773saliently
sanely93114613sa_nely
sanity9316203sanit_y
sapiently1444863sapiently
savingly1537313savingly
scantly12419553scantly
shingly143210813shingly
shinily13268933shinily
singly104015853_singly
slantly10399323slantly
spindly13257383spindly
swiftly1633733swiftly
tacitly1236223tacitly
taint55542283taint__
tainted83512423tainted
taints64520533taint_s
takingly1635913takingly
tangly104413933ta_ngly
tartly96014023ta_rtly
tautly9499503ta_utly
tawnily1335443tawnily
taxingly1935483taxingly
thinly1238673thin_ly
thistly1395963thistly
tingly103815983_tingly
tinily94014433_tinily
tinkly134811153_tinkly
twinkly1733913twinkly
unsaintly1244993unsaintly
vacantly1644073vacantly
valiantly1544193valiantly
vanity12311943vanit_y
vastly12508723va_stly
vaunty12409063vaunt_y
vyingly1794153vyingly
wanly115118023wa_n_ly
wintle94014603_wintle
wintry12498923_wintry
wrinkly17295753wrinkly
zanily18310183za_nily

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272366.97019229.1
3Display Results2362360.0932537.6
 (SQL Overall)1786912367.46923924.4
 
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.