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

227 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
fragile114784(None) 
agile65122262__agile
draggle1056102draggle
facile112514882f_acile
fragilely1662432fragilely
frail85220212fra_il_
frailer10319942fra_iler
frails93716472fra_ils
fraise94214912fra_ise
frangible1543752frangible
frazil1847222frazil_
frazils1956122frazils
frazzle18305222frazzle
gracile102512602gracile
nargile847652nargile
raggle83712882_raggle
unagile838282unagile
vagile10310542_vagile
abaxile1644083abaxile
anile54634463__anile
arabize1849343arabize
arable81821003ara_ble
argil65116883ar_gil_
argils75213623ar_gils
argle65421563ar_g_le
argyle1066063ar_gyle
axile126020513__axile
beagle93612593beag_le
brabble10349973brabble
braciole1246973braciole
brail75525553bra_il_
brailed103914013bra_iled
braille939713braille
brails84621293bra_ils
braise84318753bra_ise
braize174113113bra_ize
bramble133710033bramble
brasil8713863brasil_
brasils9410973brasils
brattle9249253brattle
brawlie12198153brawlie
brazil1779623brazil_
brazils1867753brazils
cagily12411563_cagily
crackle153611253crackle
cradle93313163cra_dle
craggily1543703craggily
crankle133610063crankle
crazily2136923crazily
daggle93711903_daggle
drabble12238883drabble
dragee84415603drag_ee
draggled1254673draggled
draggles1145963draggles
dragline1036843dragline
drail65020973dra_il_
drails74716953dra_ils
eagle64219483_eag_le
fable105824753f_a_ble
faciae112913413f_aciae
fagin9216573f_agi_n
fagins10513863f_agins
fail74840243f_a_il_
failed105421603f_a_iled
faille93414743f_aille
fails85631483f_a_ils
family143311703f_amily
famine114318193f_amine
faradise12219393faradise
faradize21237823faradize
farcie114816473farci_e
farle86929243f_a_rle
farside1138603farside
feasible1376093feasible
febrile1237153febrile
fenagle11197153fenag_le
fertile10311733fertile
fictile1238023fictile
file75446643f___ile
finagle11238313finag_le
fissile10269653fissile
flagpole1443583flagpole
flail85316183fla_il_
flailed1137303fla_iled
flails94313003fla_ils
flakily1736293flakily
flavine1338453flavine
flexile1735073flexile
foamily1546543foamily
foggily1535053foggily
fogie96719003f_ogi_e
forage104616993forag__e
foraging1358063foraging
forgive1436193forgive
frae75330473fra___e
frag85126273frag___
fragged134010153fragged
fragging14329423fragging
fragility1645553fragility
frags96322163frag__s
frailest1139493fra_ilest
frailly1337313frailly
frailty1335663fra_ilty
fraises104215693fra_ises
framable1537573framable
frame105821803fra__me
framing133014793framing
francize2246853francize
frankly17315633frankly
frappe13286953fra_ppe
fraying143413433fraying
frazzled20303993frazzled
frazzles19284813frazzles
freakily1835003freakily
freckle16106643freckle
friable122612563friable
fribble14287783fribble
frigate11311063frigate
frigid1136923frigi_d
frigidly1643123frigidly
frijole1734583frijole
frill84917563fr__ill
frise85322453fr__ise
frizzle18367043frizzle
frogeye1443813frogeye
froglet11310063frog_let
froglike1634363froglike
frugal1036393frugal_
fryable15277463fryable
fuggily1534963fuggily
fugle94915543f_ug_le
fungible1444173fungible
fusile94313493f_usile
futile93914953f_utile
gaggle93412623_gaggle
gargle84215463garg_le
grabble12339643grabble
graciles112511613graciles
grackle14338893grackle
gradine93317033gradine
grail64622873gra_il_
grails77518783gra_ils
granite82017073granite
granule839463granule
grapple12378003grapple
gratine84719193gratine
habile11515203_habile
haggle113511983_haggle
hoagie102310003hoagi_e
imagine1037873imagine
labile8315213_labile
magilp1137613_magilp
maile75232213_ma_ile
narghile1244033narghile
nargileh1272433nargileh
nargiles976793nargiles
oracle84313293ora_cle
praise84419413pra_ise
praline93019743praline
prattle9208833prattle
prefile123413183prefile
profile123211153profile
rabble103818243_rabble
racily11715173_racily
rackle123917293_rackle
raddle84816173_raddle
radiale83813523_radiale
radicle103510713_radicle
raffle123910703_raffle
rage55742353_rag__e
ragee65432663_rag_ee
raggee84217603_raggee
raggles93813283_raggles
ragi56032283_ragi__
raging85126433_raging
ragis66325603_ragi_s
ragtime1036163_ragtime
rail46147763_ra_il_
railed74727543_ra_iled
railer64524933_ra_iler
rails55937403_ra_ils
raise54828053_ra_ise
rale45050563_ra__le
ramble104519973_ramble
ramie75027823_rami_e
ramilie9310283_ramilie
rankle103414883_rankle
rapine85023083_rapine
rassle63813203_rassle
ratine65131823_ratine
ratite65022423_ratite
rattle64717613_rattle
ravine95522223_ravine
refile95122373_refile
regale74821453_regale
regild8149773_regild
regilt71217493_regilt
regime95313943_regime
regive104814323_regive
resile64627673_resile
retile65929673_retile
revile94921613_revile
rile45650533_r__ile
rutile65217683_rutile
stabile9312063stabile
stagily1139053stagily
straggle10359133straggle
trachle12311853trachle
tractile10311073tractile
tragi64717173tragi__
tragic93811543tragi_c
tragics10338083tragics
trail55126773tra_il_
trailed83415673tra_iled
trailer73015393tra_iler
trails64622513tra_ils
trample11299703trample
uracil8311543uracil_
uracils939373uracils
uralite71714103uralite
uranide82212093uranide
uranite72515693uranite
waggle113612303_waggle
wrangle1137383wrangle
wrassle10357173wrassle
wrastle10368993wrastle
wriggle12316213wriggle

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.1731032896.0
2DLD Change Limit1340272277.67017474.2
3Display Results2272270.0802837.5
 (SQL Overall)1786912277.92322553.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.