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

136 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
frescoes135783(None) 
frescoed1436051frescoed
frescoer1345981frescoer
frescoers1454561frescoers
frescos1236811fresco_s
fescues1236782f_escues
fiascoes13134922fiascoes
frenches163311632frenches
fresco1136472fresco__
frescoist1444122frescoist
freshes133515822fres_hes
prescores133912172prescores
rescores105415692_rescores
rescues9312752_rescues
reshoes102316032_reshoes
roscoes9310922_roscoes
borescopes1645173borescopes
breaches153714123breaches
breeches15258673breeches
ciscoes113610733_ciscoes
creches14313093cre_ches
cresols939653cres_ols
cresses94219813cres_ses
drenches14309803drenches
dresses83716173dres_ses
escots84211743__escots
faeces114713123fae_c_es
fasces114914543f_asc_es
fatsoes10379423fats_oes
feces105625363f_e_c_es
felloes104114383f_elloes
fences114617113f_enc_es
fescue1137493f_escue_
fesses94820253f_es_ses
fetches153413893f_etches
fiascos12124743fiasco_s
ficoes114613463f__icoes
firesides1346603firesides
firestones1347113firestones
fleches153411443fle_ches
fleeces12399643fleec_es
fleeches16287083fleeches
flenches163410533flenches
fleshes133913273fles_hes
fletches16308853fletches
flysches1933123flysches
foredoes12310803fore_does
foregoes1239523fore_goes
foresees11311643fores_ees
foreshores16107403foreshores
foreshows1875973foreshows
foresides1339703foresides
frasses104314513fras_ses
freckles17126383freckles
freebees1345353freebees
freebies1337873freebies
freedoms1445433freedoms
frees86131393fre___es
freestones1345703freestones
freezes193310353fre_ezes
frenched17299433frenched
frenzies2037713frenzies
freres94716173fre__res
frescoing1544683frescoing
frescoists1552383frescoists
freshed143312593fres_hed
freshen133010883fres_hen
freshens14298313freshens
fresher132612643fres_her
freshest143010583fres_hest
freshet133416643fres_het
freshets14298673freshets
freshmen1656023freshmen
freshness1545943freshness
fresnel1035893fres_nel
fresnels1135233fresnels
frisbees13295013frisbees
frisees104411693fris_ees
frises94124273fris__es
frissons1145043frissons
froes86126693fr___oes
fuscous1256673f_uscous
gessoes838293_gessoes
preaches153214893preaches
precodes13711573pre_codes
presages11312203presages
presales10315263presales
prescore124812373prescore
prescored14409403prescored
preshows16267023preshows
presides11414913presides
presses93523153pres_ses
pressors103212693pressors
prestores114716083prestores
prestos93716083presto_s
presumes1239843presumes
reaches123423203_reaches
recces10614913_re_cces
recodes102918633_re_codes
recons84922993_re_cons
redoes74623773_re_does
reechoes1338413_reechoes
resales74724903_resales
rescales103414573_rescales
rescore95616203_rescore
rescored114513103_rescored
rescue8313003_rescue_
rescued10410043_rescued
rescuer939033_rescuer
rescuers1037363_rescuers
resees63827483_res_ees
reshes94124363_res_hes
reshoe92816483_reshoe_
reshoed112212153_reshoed
reshows132510453_reshows
resides84523283_resides
resiles74026543_resiles
resites74027793_resites
resizes164216843_resizes
resods74116303_res_ods
resoles73823653_resoles
resows93915353_res_ows
respots92912763_respots
restokes125213043_restokes
restores85222993_restores
resumes9313373_resumes
retches123318513_retches
roscoe839763_roscoe_
toeshoes1147713toeshoes
treacles1039703treacles
trenches133512603trenches
tresses73719543tres_ses
trestles83012553trestles
wrenches163210233wrenches
wrestles113310063wrestles
wretches16257283wretches

Search took 9 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.420425454.8
2DLD Change Limit1461621367.53019410.6
3Display Results1361360.0632158.7
 (SQL Overall)1786911368.01322300.1
 
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.