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 “fuels” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

148 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
fuels8711735(None) 
duels65619231duels
feels85223041feels
fuel76824731fuel_
fulls84623521fulls
furls85322051furls
fusels94412451fusels
axels126313632axels
bels66142492_bels
buhls105111802buhls
bulls75629572bulls
burls74228852burls
cels65534972_cels
cues65438982cue_s
culls75425812culls
cupels10310202cupels
curls74927102curls
defuels11296982defuels
dels56745472_dels
duals65620082duals
duel56729702duel_
dues56045502due_s
duets65323882duets
dulls64523742dulls
eels46536742_eels
els37645722__els
fails85631482fails
falls85727652falls
farls85731112farls
feds85234312f_eds
feebs106112682feebs
feeds94921142feeds
feel75233842feel_
fees76450602f_ees
fehs106522382f_ehs
fell76833072f_ell
fells85327382fells
felt75146932f_elt
felts85324542f_elts
fems96428702f_ems
fens76139762f_ens
fes66551672f_e_s
fess76529162f_ess
fets75345942f_ets
feuds95914882feuds
feus75830752f_eus
fiefs116213702fiefs
field95015322field
fields104211042fields
files85441272files
fills84632372fills
fils75838692f_ils
fjeld16465582fjeld
fjelds17414472fjelds
fleas86423662fleas
flees85828752flees
flews115316442flews
fleys117015602fleys
flues84626922flue_s
foals85721692foals
foes76543442foe_s
foils85025812foils
fools86824202fools
fouls87221432fouls
fowls115518892fowls
frees86131392frees
frets85523402frets
fubs96328792fu_bs
fucks144419252fucks
fucus105515892fucus
fuds86528562fu_ds
fueled104913602fueled
fueler94313932fueler
fuelers103912392fuelers
fugle94915542fugle
fugles104715782fugles
fugs85730692fu_gs
fugus95914012fugus
fujis15379242fujis
full75229152fu_ll
fully114820862fully
fumers113613382fumers
fumes105224702fumes
fumets114311812fumets
funds94119252funds
funks125318912funks
funnels10348172funnels
funs75235732fu_ns
furl77030882furl_
furs76735042fu_rs
fusees95416402fusees
fusel85218492fusel_
fuses85628422fuses
fusils93912342fusils
fuss76027932fu_ss
fuzees184910752fuzees
fuzes175120222fuzes
fuzils18407962fuzils
gels56836102_gels
gruels73910152gruels
guess64213362guess
gules64831042gules
gulls65222982gulls
guls55930852gu_ls
heels85625532heels
hues75235232hue_s
hulls84923562hulls
hurls86522712hurls
jurels133710582jurels
keels94622412keels
koels94613902koels
kues86426772kue_s
kugels1146072kugels
lues45943552lue_s
lulls54119652lulls
mels65941532_mels
mules75034292mules
mulls75124152mulls
noels56418702noels
nulls55019982nulls
nurls55519682nurls
ousels64815272ousels
ouzels15408702ouzels
peels75226422peels
pules74538812pules
pulls74425052pulls
puls65437562pu_ls
purls74723352purls
quell144311422quell
quells15359692quells
queys17398362queys
reels55333262reels
refuels10399522refuels
riels55121332riels
rubels84112992rubels
ruers515019412ruers
rues46044482rue_s
rules55234252rules
seels55632822seels
sels46345982_sels
suers55128482suers
sues46247652sue_s
suets55126102suets
taels56822072taels
teels55726372teels
tels46841692_tels
tules54532792tules
yules84521582yules

Search took 3 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 Filter178691538000.0762351197.4
2DLD Change Limit538001482.37322671.7
3Display Results1481480.0801850.0
 (SQL Overall)1786911482.52970656.8
 
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.