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

201 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
fresco113647(None) 
frescos1236811frescos
alfresco1341532alfresco
fiasco11104922fiasco
french143511212french
frescoed1436052frescoed
frescoer1345982frescoer
frescoes1357832frescoes
fresh115012202fres_h
presto84216202presto
afresh1255503afres_h
arco68331543ar__co
areca75618633are_ca
areic73219393areic_
ares45871023ares__
aristo6414033aristo
arseno6318913arseno
breach134213723breach
breech13348263breech
bronco10179493bronco
cisco95112133_cisco
credo84815563cre_do
cresol8310203cresol
cress75022833cres_s
cressy11439113cressy
crest74632693cres_t
crests85218703crests
cresyl1135133cresyl
deco76125973_de_co
disco85616073_disco
dreck124812803dre_ck
dreich12377723dreich
drench12369593drench
dress65319833dres_s
dressy10518143dressy
drest65530343dres_t
erect74129333ere_ct
escot75320083__escot
fares85852873fares__
fatso85113493fats_o
feck134923433f_e_ck
fees76450603fees__
fence105319913f_ence
feres86038183feres__
fes66551673f_es__
fescue1137493f_escue
fess76529163f_es_s
fesse86116333f_esse
fest74949443f_es_t
fests85828043f_ests
fetch134913473f_etch
fiascos12124743fiascos
fico95824593f__ico
fierce11348913fierce
fiesta938123fiesta
fires85740753fires__
fisc96819753f_isc_
fiscs105311883f_iscs
fleck148213593fle_ck
fleece11369903fleece
fleech14367343fleech
fleecy14266483fleecy
flench144010813flench
flesh115013743fles_h
fleshy15406283fleshy
fletch14388193fletch
flysch1732893flysch
foes76543443foes__
foredo10510823fore_do
forego1038903fore_go
fores85847103fores__
foresaw1377133foresaw
foresee10414333foresee
foreshow1785893foreshow
forest94926743fores_t
forests104114953forests
franc104615413franc_
francs114112193francs
frass85321123fras_s
freak125115243fre_ak
freaks134713063freaks
freaky16439233freaky
free75940183fre__e
freed95223543fre_ed
freedom1345853freedom
freely12310953freely
freer86021243fre_er
freers94717303freers
frees86131393fre_es
freesia1046323freesia
freest95318283freest
freeze18349513freeze
fremd115010323fre_md
frena85915273fre_na
frenum1188803frenum
frenzy2135883frenzy
frere85617723fre_re
freres94716173freres
frescoers1454563frescoers
frescoing1544683frescoing
frescoist1444123frescoist
freshed143312593freshed
freshen133010883freshen
fresher132612643fresher
freshes133515823freshes
freshet133416643freshet
freshly16286833freshly
fresnel1035893fresnel
fret75845043fre__t
frets85523403fre_ts
fretsaw1343923fretsaw
fretty1249223fretty
fries85535603fries__
frise85322453fris_e
frisee94217993frisee
frises94124273frises
frisk125312373fris_k
frisks13479263frisks
frisky16406673frisky
frisson1045313frisson
fro65530643fr___o
frock145314653fr_ock
froes86126693froes__
frosh115713403fros_h
frost84727833fros_t
frosts94214623frosts
frosty124710633frosty
frusta937453frusta
gesso649603_gesso
grego7310523gre_go
ires45639283ires__
lesbo739253_lesbo
ores46056683ores__
peso66925823_pes_o
pesto75723723_pesto
pisco96314983_pisco
preach133613923preach
preact103220393preact
presa74319043pres_a
prescore124812363prescore
prese75228383pres_e
preset84430983preset
preshow15237413preshow
press75425953pres_s
pressor93512873pressor
prest75736353pres_t
prestos93716083prestos
prests84021263prests
proso77222413pros_o
reach105123883_reach
react74634333_react
rec55645463_re_c_
recce9514563_recce
reck106130563_re_ck
recon75624243_re_con
recs65734183_re_cs
recto74520803_recto
redo56029363_re_do
reecho11318653_reecho
repo66027543_re_po
repro75315913_repro
res35565043_res__
resat55139683_resat
resaw84117253_resaw
resay85320543_resay
rescore95616193_rescore
rescue8313003_rescue
resect84424703_resect
resee54336333_resee
reset55051863_reset
resew84519503_resew
resh76523453_res_h
reshod103012233_reshod
reshoe92816483_reshoe
reshot93519633_reshot
reshow123111433_reshow
resid64124093_resid
resin54131053_resin
resit54241043_resit
resod64720053_resod
resow88217243_resow
respot83117633_respot
rest46459843_res_t
rests54935873_rests
retch104818303_retch
retro55020953_retro
roscoe839763_roscoe
secco9312423_secco
telco7511873_telco
trench114211613trench
tres46542903tres__
tress55423163tres_s
tressy9448553tressy
uredo65112993ure_do
ureic74514463ureic_
verso85314633vers_o
wreck144611043wre_ck
wrench14439353wrench
wrest84925433wres_t
wrests95313083wrests
wretch14326533wretch

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127162016.28017948.4
3Display Results2012010.0633190.5
 (SQL Overall)1786912016.49927495.2
 
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.