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

177 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
frailty133566(None) 
frailly1337311frailly
faulty12429362f_aulty
fealty122910222fea_lty
fragility1645552fragility
frail85220212frail__
frailer10319942frailer
frails93716472frail_s
frilly124111442fr_illy
fruity12429692frui_ty
orality101111682orality
anality10313633anality
arability14411013arability
artily92814713artil_y
aurality1139223aurality
bailey115015673_bailey
brail75525553brail__
brailed103914013brailed
braille939713braille
brails84621293brail_s
brainy114815643brai_ny
bratty1159683bra_tty
brawly144312353brawl_y
crafty14478913cra_fty
crawly144610763crawl_y
crazily2136923crazil_y
cruelty1234113cruelty
daily95922333_dail_y
dainty105311473_dainty
drably123511613drabl_y
drafty13638933dra_fty
drail65020973drail__
drails74716953drail_s
drawly134910723drawl_y
drifty13418223dr_ifty
drily95816523dr_il_y
duality1147963duality
facility1638243facility
faculty1535573faculty
fail74840243f_ail__
failed105421603f_ailed
faille93414743f_aille
fails85631483f_ail_s
faint85837063f_aint_
faintly1337083f_aintly
faints94818783f_aints
fairly125610013f_airly
fairy115318283f_ai_ry
faith115620853f_ai_th
family143311703famil_y
fatality1438443fatality
fatly115716803f_atl_y
fatty115117413f_a_tty
fault85428313f_ault_
faults94513553f_aults
featly123711753featl_y
feisty12449293f_eisty
feracity1646733feracity
ferity122813343feri_ty
fertility1547203fertility
fifty145211423f__ifty
filly114424903f__illy
filmy136114043f__ilmy
filth115015823f__ilth
filthy15356423f__ilthy
finality1448343finality
fitly115114973f__itly
fixity19427803fixi_ty
flail85316183flail__
flailed1137303flailed
flails94313003flail_s
flakily1736293flakil_y
flatly123110213flatl_y
flaunty1354413flaunty
flinty126112493f_linty
flirty12499143f_lirty
foamily1546543foamil_y
formality1746993formality
foxily1947253foxil_y
fracti1139963fra_cti
fragile1147843fragil_e
fragilely1662433fragilely
frailest1139493frailest
frailties1245853frailties
fraise94214913frai_se
fraises104215693fraises
frankly17315633frankly
frat75648543fra__t_
frats86829673fra__ts
fray105428903fra___y
frazil1847223frazil__
frazils1956123frazil_s
freakily1835003freakil_y
freely12310963freel_y
fretty1249223fr_etty
friability1847893friability
friarly13316213friarly
friary124010093fr_iary
frill84917563fr_il_l
frills94414223fr_ills
fringy13309263fr_ingy
frisky16406673fr_isky
frit77044473fr_i_t_
frith115922033fr_i_th
frits86129103fr_i_ts
fritt86129413fr_i_tt
fritts94613193fr_itts
fritz176020773fr_i_tz
frizzy20555833fr_izzy
frosty124710633fr_osty
frowsty16464983frowsty
frugality1653263frugality
fruit85122223frui_t_
fruits94512493frui_ts
furmity1535183furmi_ty
furrily1337613furril_y
futility1446973futility
gaiety10119373_gaiety
gaily95020973_gail_y
gracility1546203gracility
grail64622873grail__
grails77518783grail_s
grainy103914213grai_ny
gravity1437183gravity
grayly13287963grayl_y
gritty10338403gr_itty
guilty10418233_guilty
kilty125213893__kilty
krait94726773krai_t_
kraits104912203krai_ts
laity85318903_lai_ty
lealty92910603lea_lty
malty106721703_ma_lty
milty104720073__milty
morality131110333morality
orally93113593ora_lly
ovality1377593ovality
painty114714753_painty
parity114719873pari_ty
quality1938563quality
racily11715173_racil_y
rail46147763_rail__
railed74727543_railed
railer64524933_railer
rails55937403_rail_s
railway1345313_railway
rainy85921083_rai_ny
raita54623073_rai_ta
rally84725903_ra_lly
raptly11338913_raptly
rarity93615493_rarity
rattly94111543_rattly
ratty84819593_ra_tty
rawly115115833_rawl_y
reality10313573reality
realty92713693_realty
rialto638603_rialto
riley84420583_r_iley
roily86121113_roil_y
rurality1137403rurality
salty85524383_sa_lty
silty84721633__silty
straitly1136563straitly
trail55126773trail__
trailed83415673trailed
trailer73015393trailer
trails64622513trail_s
trait56940843trai_t_
traits65121983trai_ts
trawley13317303trawley
trilby1144973tr_ilby
uralite71714103uralite
variety1337743variety
vaulty12388443_vaulty
warily122915093waril_y
wraith1258603wrai_th
wristy12509703wr_isty

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 Limit1340271775.87622809.2
3Display Results1771770.0632809.5
 (SQL Overall)1786911776.34228175.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.