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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
frescoer134598(None) 
frescoed1436051frescoed
frescoers1454561frescoers
frescoes1357831frescoes
fresco1136472fresco__
frescos1236812fresco_s
fresher132612642fres_her
prescore124812372prescore
rescore95616202_rescore
rescuer939032_rescuer
bescour1145203_bescour
breacher153011503breacher
drencher14257213drencher
dresser83611953dres_ser
dressier956863dressier
erecter93113393ere_cter
fencer114613533f_enc_er
fescue1137493f_escue_
fescues1236783f_escues
fester94723513f_es_ter
fetcher153510393f_etcher
fiascoes13134923fiascoes
fiercer12356953fierc_er
fleecer12368033fleec_er
fleecier1334763fleecier
flesher133610923fles_her
fleshier1435603fleshier
fletcher16306663fletcher
foregoer1237253fore_goer
foreseer1139013fores_eer
foreshore15118213foreshore
forester11313673fores_ter
foreswore15117403foreswore
freakier15246483freakier
freer86021243fre___er
freezer19348523fre_ezer
frenched17299433frenched
frenches163311633frenches
frescoing1544683frescoing
frescoist1444123frescoist
freshed143312593fres_hed
freshen133010883fres_hen
freshener1544853freshener
freshes133515823fres_hes
freshet133416643fres_het
freshmen1656023freshmen
fresnel1035893fres_nel
fretter103412753fre_tter
frettier1156593frettier
frisker14389273fris_ker
friskier1535193friskier
frostier1148163frostier
preacher153211373preacher
presager1138443presager
prescored14409403prescored
prescores133912173prescores
presider11410423presider
presser93717623pres_ser
pressor93512883presso_r
prester93519623pres_ter
prestore104217353prestore
presumer1247583presumer
reacher123718293_reacher
recover124312623_re_cover
rescored114513103_rescored
rescores105415693_rescores
rescue8313003_rescue_
rescued10410043_rescued
rescuers1037363_rescuers
rescues9312753_rescues
reshoe92816483_reshoe_
reshoed112212153_reshoed
reshoes102316033_reshoes
reshower14107063_reshower
resider84615803_resider
rester63832433_res_ter
restore75822983_restore
restorer84813723_restorer
resumer9410113_resumer
roscoe839763_roscoe_
roscoes9310923_roscoes
trencher13279313trencher
tressier847963tressier
tressour844573tressour
wrecker16367603wre_cker
wrencher16287783wrencher
wrester102812413wres_ter
wrestler11306993wrestler

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 Filter1786911461620.423422437.4
2DLD Change Limit146162887.23320207.7
3Display Results88880.0302933.3
 (SQL Overall)178691887.68623248.9
 
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.