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

198 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
precasts123945(None) 
precast11314851precast_
recasts93413531_recasts
breasts939702bre_asts
forecasts1445802forecasts
preacts113211362pre_acts
precents123015042precents
precepts14268892precepts
precess11310862preces_s
precises123218332precises
precuts111710472prec_uts
prepaste12139082prepaste
prepastes13128822prepastes
prests84021262pre__sts
pretaste10139522pretaste
pretastes11119422pretastes
pretests10310012pretests
recants93217092_recants
recast83422772_recast_
repasts93611932_repasts
arecas84817443areca__s
beasts84519723_be_asts
breast8319633bre_ast_
casts77237793___casts
creases94020963cre_ases
crests85218703cre__sts
decants103514443_decants
demasts1089223_demasts
dicasts1078703_dicasts
easts57530323__e_asts
erects84116183erec__ts
feasts95116093_fe_asts
forecast1349763forecast_
foremasts1445793foremasts
fracases1336993fracases
greases84816713gre_ases
greats76318393gre_a_ts
leasts64616413_le_asts
miscasts1238353miscasts
offcasts1643013offcasts
orgiasts943803orgiasts
outcasts10108683outcasts
overcasts14217853overcasts
parecisms1547163parecisms
pasts75936503p___asts
peases85229473p_e_ases
peats76140193p_e_a_ts
pecans101515833p_eca_ns
pectases122411193p_ectases
pedants10310113p_edants
pederasts1255203pederasts
peltasts1035703peltasts
percales12313803percales
percents122713373percents
percepts14247643percepts
percuss1137163percus_s
periapts1237273periapts
persalts1038193persalts
persists1049183persists
pests75933273p_e__sts
petasos948603p_etasos
petasus946363p_etasus
piecrusts1342603piecrusts
pietists1038323pietists
pleases94515483ple_ases
pleats85218593ple_a_ts
plenists1038253plenists
polecats1248833poleca_ts
prases84429023pr__ases
prats76333393pr__a_ts
preaches153214893preaches
preact103220393pre_act_
preadapts1444003preadapts
preamps1336613pre_amps
prearms11369173pre_arms
prebakes1639013prebakes
prebasal1244723prebasal
precasting15169833precasting
precava1445093preca_va
precavae1544813precavae
precaval1544723precaval
precedes13310713precedes
precent113520263precent_
precept133112513precept_
precesses13310463precesses
precincts1544993precincts
precious12310593precious
precipes143212213precipes
precis103416703prec__is
precise113518173precis_e
precised133213413precised
preciser123411663preciser
precisest13259003precisest
precodes13711573precodes
precooks1656763precooks
precools1237703precools
precrash1544823precras_h
precreases1445653precreases
precrisis1346453precrisis
precures12312903precures
precut102016533prec_ut_
predate10616893preda_te
predates11615813predates
predawns1444363predawns
predicants1546063predicants
predicts1339613predicts
predusks1543423predusks
preedits1168763preedits
preempts1444543preempts
preenacts1345843preenacts
preexists1844733preexists
prefabs1435163prefa_bs
prefaces15311063prefaces
prefades1439533prefades
prefects1598133prefects
pregames1339003pregames
preheats1339413preheats
prelate9519693prela_te
prelates10418573prelates
prelects1299723prelects
premises123018273premises
premiss113513813premis_s
prenames12311643prenames
prepacks1836583prepacks
prepares122014163prepares
prepasted14137673prepasted
prepaves15189193prepaves
prepays1437483prepa_ys
presages11312203presages
presales10315263presales
presents103315643presents
presets94216423pre_sets
presifts1366593presifts
presorts105311683presorts
press75425953pre__s_s
presses93523153pre_sses
prest75736353pre__st_
presto84216203pre__sto
prestos93716083pre__stos
pretapes122811533pretapes
pretasted12147963pretasted
pretest9517633pretest_
pretexts1735603pretexts
prevails1337663prevails
prevents133012293prevents
previses133814283previses
previsits1446793previsits
prewarms15406733prewarms
prewarns13456943prewarns
prewash1535213prewas_h
prewashes1744753prewashes
prickets16329083prickets
priests93810863pr_iests
procarps1445973procarps
process11310403proces_s
prosaists1157503prosaists
protases102115033protases
protasis102411973protasis
protests10310493protests
protists10313363protists
provosts1336083provosts
racists92613323_racists
reacts83616603_re_acts
rebaits9312573_rebaits
recalls92613623_recalls
recanes93222263_recanes
recant83228683_recant_
recaps103615733_reca_ps
recepts113010263_recepts
recess8314263_reces_s
recharts1337663_recharts
recits83621353_rec_its
reclasps1235053_reclasps
recoats92616643_recoats
recuses94619463_recuses
recuts83817373_rec_uts
redacts10510943_redacts
reests64618893_re_ests
relists73817053_relists
renests74014213_renests
repass84114703_repas_s
repast83520633_repast_
resists74414923_resists
rests54935873_re__sts
retaste72313133_retaste
retastes82212903_retastes
retests73813853_retests
revests104413733_revests
roasts64915413_r_oasts
secants93413893_secants
telecasts1145543telecasts
treats64821693tre_a_ts
typecasts1642823typecasts
upcasts11185643_upcasts
ureases74416723ure_ases
webcasts1543313webcasts
wrests95313083wre__sts
yeasts96413053_ye_asts

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.423422437.4
2DLD Change Limit1461621987.57619292.8
3Display Results1981980.0802475.0
 (SQL Overall)1786911988.07922118.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.