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

176 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
fresnel103589(None) 
fresnels1135231fresnels
crenel84213062cre_nel
fennel9429472f_ennel
freshed143312592freshed
freshen133010882freshen
fresher132612642fresher
freshes133515822freshes
freshet133416642freshet
tressel73010892tressel
arene55329413are_ne_
arenes64928393are_nes
arsenal739383arsenal
creel75121483cre__el
crenels93711013cre_nels
cresol8310203cres_ol
cresses94219813cresses
cresset93319943cresset
crestal9312133crestal
crested103416533crested
cresyl1135133cres_yl
crewel114310473cre_wel
diesel74410403dies_el
dreidel934473dreidel
dressed93511873dressed
dresser83611953dresser
dresses83716173dresses
esne47018793__esne_
esnes54817363__esnes
feel75233843f_e__el
fennec11326913f_ennec
fennels10387903f_ennels
ferine96422583ferine_
ferrel92810203f_errel
fesse86116333f_esse_
fessed104515063f_essed
fesses94820253f_esses
festal94213563f_estal
fester94723513f_ester
flannel1035423flannel
flense938903flense_
flensed1136613flensed
flenser1036783flenser
flenses1039473flenses
fleshed143210263fleshed
flesher133610923flesher
fleshes133913273fleshes
forefeel14105513forefeel
foreknew1843733foreknew
foresail1147823foresail
foresee10414333fores_ee
foreseen1139103foreseen
foreseer1139013foreseer
foresees11311643foresees
forestal11410283forestal
forested12312463forested
forester11313673forester
frasses104314513frasses
freaked15399703freaked
freckle16106643freckle
free75940183fre__e_
freebee1238043freebee
freed95223543fre__ed
freely12310953fre__ely
freemen1238463freemen
freeness11710443freeness
freer86021243fre__er
frees86131393fre__es
freeze18349513freeze_
freezer19348523freezer
freezes193310353freezes
frena85915273fre_n_a
french143511213fre_nch
frenula1045623fre_nula
frenum1188803fre_num
frenzy2135883fre_nzy
frere85617723fre_re_
freres94716173fre_res
fresco1136473fres_co
frescoed1436053frescoed
frescoer1345983frescoer
frescoes1357833frescoes
frescos1236813frescos
fresh115012203fres__h
freshened1645253freshened
freshener1544853freshener
freshens14298313freshens
freshest143010583freshest
freshets14298673freshets
freshly16286833freshly
freshmen1656023freshmen
freshness1545943freshness
fretful1346143fretful
fretted113411853fretted
fretter103412753fretter
frisbee12298513frisbee
frise85322453fris_e_
frisee94217993fris_ee
frisees104411693frisees
frises94124273fris_es
frisked15478823frisked
frisker14389273frisker
frisket143811773frisket
frosted113211873frosted
frowned14348833frowned
frowner13429683frowner
funnel93610743f_unnel
fusel85218493f_us_el
grapnel1035603grapnel
greened93111263greened
greener83111713greener
kennel10369213_kennel
kernel104010583_kernel
mesne75116293_mesne_
mesnes85216213_mesnes
preanal9310713preanal
preened103214983preened
preener93114833preener
prequel1836343prequel
presale9416353presale
prese75228383pres_e_
presell939293presell
present94022733present
preset84430983pres_et
pressed103317313pressed
presser93717623presser
presses93523153presses
prester93519623prester
pretzel1835143pretzel
rebel73421293_re_bel
reel45240533_re__el
refeel93913243_refeel
refel84920813_re_fel
refuel93912623_refuel
regnal74812933_regnal
reheel93610823_reheel
reined74425523_reined
renal55929503_re_nal
renew83917513_re_new
rennet64624853_rennet
repanel939963_repanel
repel74921403_re_pel
resail64418733_resail
resale64025543_resale
reseal64819643_reseal
resee54336333_res_ee
reseed74823293_reseed
reseek103813133_reseek
reseen64318413_reseen
resees63827483_resees
resell64215203_resell
resend75016773_resend
resent63833623_resent
reset55051863_res_et
resew84519503_res_ew
reshes94124363_reshes
resile64627673_resile
resined84522653_resined
resmelt9411773_resmelt
resole64624183_resole
respell947023_respell
respelt9312143_respelt
rested74430783_rested
rester63832433_rester
revel84423163_re_vel
ronnel63310883_ronnel
runnel63510663_runnel
tressed83714253tressed
tressels8367653tressels
tresses73719543tresses
trestle72611363trestle
trunnel745403trunnel
vessel937953_vessel
wrested113410933wrested
wrester102812413wrester
wrestle10298843wrestle

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.1531167915.0
2DLD Change Limit1340271766.69020033.9
3Display Results1761760.0632793.7
 (SQL Overall)1786911766.90625874.7
 
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.