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

116 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
frescoed143605(None) 
frescoer1345981frescoer
frescoes1357831frescoes
frenched17299432frenched
fresco1136472fresco__
frescoers1454562frescoers
frescos1236812fresco_s
freshed143312592fres_hed
prescored14409402prescored
rescored114513102_rescored
rescued10410042_rescued
reshoed112212152_reshoed
breached163411643breached
breeched16337383breeched
crested103416533cres_ted
discoed11312483_discoed
drenched15247913drenched
dressed93511873dres_sed
erected103213993ere_cted
escoted1038183__escoted
fenced124412713f_enc_ed
fescue1137493f_escue_
fescues1236783f_escues
fessed104515063f_es_sed
fetched163710473f_etched
fiascoes13134923fiascoes
flecked17358073fle_cked
fleeced13358153fleec_ed
fleeched17345823fleeched
flenched17267963flenched
fleshed143210263fles_hed
fletched17306693fletched
foreshowed2044063foreshowed
forested12312463fores_ted
fracted1339373fr_acted
freaked15399703fre_aked
freckled18104443freckled
freed95223543fre___ed
freehold1554683freehold
freeload1244733freeload
frenches163311633frenches
frenzied2144043frenzied
frescoing1544683frescoing
frescoist1444123frescoist
freshen133010883fres_hen
freshened1645253freshened
fresher132612643fres_her
freshes133515823fres_hes
freshet133416643fres_het
freshmen1656023freshmen
fresnel1035893fres_nel
fretted113411853fre_tted
frisked15478823fris_ked
frocked17439333fr_ocked
frosted113211873fros_ted
gessoed935743_gessoed
preached163412063preached
preacted132710943preacted
precode12311853pre_code
precoded1438863pre_coded
presaged1238803presaged
prescind1338393prescind
prescore124812373prescore
prescores133912173prescores
preshowed1875183preshowed
presided12410553presided
presold1059603pres_old
pressed103317313pres_sed
prestored125111673prestored
presumed1337973presumed
reached134619083_reached
reacted103015713_reacted
recked134821803_re_cked
recode93618713_re_code
recoded113115033_re_coded
record96117433_re_cord
reechoed1436083_reechoed
resawed113111183_resawed
rescaled113311303_rescaled
rescind10410393_rescind
rescore95616203_rescore
rescores105415693_rescores
rescue8313003_rescue_
rescuer939033_rescuer
rescues9312753_rescues
resected112514743_resected
reseed74823293_res_eed
resewed113011823_resewed
reshod103012233_resho_d
reshoe92816483_reshoe_
reshoes102316033_reshoes
reshowed15117063_reshowed
resided95217703_resided
resiled84621983_resiled
resined84522653_resined
resited85122423_resited
resized174614903_resized
resod64720053_res_o_d
resold73915363_res_old
resoled84119283_resoled
resowed113712253_resowed
respond1039113_respond
rested74430783_res_ted
restoked135710533_restoked
restored96417193_restored
resumed10310623_resumed
retched133814273_retched
roscoe839763_roscoe_
roscoes9310923_roscoes
trenched14289853trenched
tressed83714263tres_sed
wrecked17418333wre_cked
wrenched17748133wrenched
wrested113410933wres_ted
wrestled12296763wrestled
wretched17276533wretched

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 Filter1786911461620.410435831.7
2DLD Change Limit1461621166.40322827.1
3Display Results1161160.0462521.7
 (SQL Overall)1786911166.85926052.0
 
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.