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

234 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
frailly133731(None) 
frailty1335661frailty
frilly124111441fr_illy
braille939712braille
faille93414742f_aille
fairly125610012f_airly
filly114424902f__illy
fragilely1662432fragilely
frail85220212frai_l_
frailer10319942frailer
frails93716472frai_ls
frankly17315632frankly
friarly13316212friarly
frill84917562fr_ill_
frills94414222fr_ills
orally93113592ora_lly
rally84725902_ra_lly
aerially11911913aerially
ally76935643__a_lly
anally9513503ana_lly
areally10411243areally
aridly105513703ar_idly
armilla936993armilla
artily92814713arti_ly
aurally10310543aura_lly
axially1737233axially
bailey115015673_bailey
bally105530103_ba_lly
barilla9310323barilla
billy105525363__billy
brail75525553brai_l_
brailed103914013brailed
brailled1147193brailled
brailler1036883brailler
brailles1039493brailles
brails84621293brai_ls
brainily1337313brainily
brainy114815643brai_ny
brambly16296253brambly
brashly15427613brashly
bravely15428233bravely
brawly144312353bra_wly
brill74819953br_ill_
brillo84211003br_illo
brills84916293br_ills
brolly114510853br_olly
chally144314293cha_lly
chilly144113223_chilly
civilly1535483civilly
crackly18397703crackly
cranially1447893cranially
crankly16358123crankly
crassly1276653crassly
crawly144610763cra_wly
crazily2136923crazily
cruelly1236563cruelly
daily95922333_dai_ly
dally95324743_da_lly
dilly94923783__dilly
drably123511613dra_bly
drail65020973drai_l_
drails74716953drai_ls
drawly134910723dra_wly
drill64718263dr_ill_
drills74414203dr_ills
drily95816523dr_i_ly
drolly105411673dr_olly
dually103210063dua_lly
evilly1236593_evilly
facially1637643facially
facilely1644363facilely
fail74840243f_ai_l_
failed105421603f_ailed
failles102914133f_ailles
fails85631483f_ai_ls
faintly1337083f_aintly
fairy115318283f_ai_ry
fall75535313f_a_ll_
falls85727653f_a_lls
family143311703f_amily
fatally1339893fatally
fatly115716803f_a_tly
faulty12429363f_aulty
fealty122910223fea_lty
feasibly1644743feasibly
featly123711753fea_tly
felly114922803f__elly
fertilely1544273fertilely
fervidly1863323fervidly
fetidly1435013fetidly
filially1447003filially
fill75540193f__ill_
fille84327403f__ille
fillo84319783f__illo
fills84632373f__ills
filmy136114043f__ilmy
finally13310103finally
fitly115114973f__itly
flail85316183flai_l_
flailed1137303flailed
flails94313003flai_ls
flakily1736293flakily
flatly123110213fla_tly
florally1447033flora_lly
fluidly1434813fluidly
foamily1546543foamily
focally15188553focally
folly115022603f__olly
forcibly1843863forcibly
formally1638243formally
foully1239013f_oully
foxily1947253foxi_ly
fragile1147843fragile
fragility1645553fragility
frailest1139493frailest
fraise94214913frai_se
fraises104215693fraises
franticly1744013franticly
fray105428903fra___y
frazil1847223frazil_
frazils1956123frazils
frazzle18305223frazzle
freakily1835003freakily
freckly19124593freckly
freely12310963fr_eely
freshly16286833freshly
friable122612563friable
friary124010093fr_iary
frigidly1643123frigidly
frilled113911603fr_illed
friller104111743fr_iller
fringy13309263fr_ingy
frisky16406673fr_isky
frizzly21455793frizzly
frizzy20555833fr_izzy
frugally1544403frugally
fruitily1445143fruitily
fruity12429693frui_ty
fugally1435603fugally
fully114820863f__ully
furrily1337613furri_ly
fusibly1535863fusibly
fusilli1044233fusilli
futilely1444083futilely
gaily95020973_gai_ly
gainly1049323_gainly
gally95026173_ga_lly
gilly94321633__gilly
grail64622873grai_l_
grails77518783grai_ls
grainy103914213grai_ny
grandly1238743grandly
gravelly15385773gravelly
gravely14469063gravely
gravidly1653743gravidly
grayly13287963gra_yly
grill64617893gr_ill_
grille74315743gr_ille
grills74314803gr_ills
grimly12459933gr_imly
grisly104310583gr_isly
gyrally1435583gyra_lly
hilly114422163__hilly
illy76925333___illy
irately1047683irately
jurally1736963jura_lly
krill94213643kr_ill_
krills104211283kr_ills
leally94012613lea_lly
maill74420793_maill_
maills84215283_maills
mainly11411493_mainly
morally12411493mora_lly
orality101111683orality
ovally12278443ova_lly
pally105727123_pa_lly
plainly1236473plainly
prill74117943pr_ill_
prills84015613pr_ills
primly13439623pr_imly
rabidly1336253_rabidly
racially1339623_racially
racily11715173_racily
radially1239783_radially
rail46147763_rai_l_
railed74727543_railed
railer64524933_railer
raillery1134953_raillery
rails55937403_rai_ls
railway1345313_railway
rainily10310433_rainily
rainy85921083_rai_ny
rallye95110163_ra_llye
rankly133910453_rankly
rapidly1336523_rapidly
raptly11338913_raptly
rarely93513653_rarely
rashly123410213_rashly
rattly94111543_rattly
ravelly13268353_ravelly
rawly115115833_ra_wly
really93315613_really
riley84420583_r_iley
rill45140903_r_ill_
rille55728733_r_ille
rills55032713_r_ills
roily86121113_roi_ly
rurally1038303rura_lly
sally85129713_sa_lly
serially11912843serially
shrilly13318563shrilly
silly84527623__silly
staidly1136683staidly
stilly93714093_stilly
straitly1136563straitly
taille63116923_taille
tally84526863_ta_lly
trail55126773trai_l_
trailed83415673trailed
trailer73015393trailer
trails64622513trai_ls
trawley13317303trawley
trigly103810943tr_igly
trilby1144973tr_ilby
trill55122933tr_ill_
trills64319853tr_ills
trimly114410893tr_imly
triply114211023tr_iply
trolly94012363tr_olly
vainly1258503_vainly
virally1339653vira_lly
wally114625093_wa_lly
warily122915093wari_ly
willy115321913__willy

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.403443402.0
2DLD Change Limit1340272346.39320964.6
3Display Results2342340.0763078.9
 (SQL Overall)1786912346.87226002.8
 
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.