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

196 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
predicts133961(None) 
predict12315321predict_
credits1039972credi_ts
edicts94911702__edicts
preacts113211362pre_acts
precincts1544992precincts
predicants1546062predicants
predicate14411782predicate
predicates15410822predicates
predicted1538912predicted
predictor1447092predictor
predictors1547262predictors
preedits1168762preedi_ts
prefects1598132prefects
prelects1299722prelects
presifts1366592presifts
products1376512products
redacts10510942_redacts
relicts94414592_relicts
verdicts1446012verdicts
addicts1176013_addicts
benedicts1443573benedicts
coedits10310243coedi_ts
credit9315193credi_t_
cretics112911653cretic_s
crevices1536713crevices
deducts1166593_deducts
delicts104012253_delicts
depicts12358463_depicts
derelicts12154183derelicts
edict84722283__edict_
edits65819033__edi_ts
educts9439893__educts
erects84116183ere__cts
evicts11368553__evicts
herdics13249523herdic_s
indicts103210723_indicts
irenics937833irenic_s
maledicts1443393maledicts
medicks16368413_medicks
medicos12339833_medicos
medics114115353_medic_s
pandects1335843pandects
pandits103914213pandi_ts
paretics122312443paretic_s
parodists1248513parodists
pedants10310113p_edants
pedicab1446693p_edicab
pedicabs1544593p_edicabs
pedicel1237813p_edicel
pedicels1336253p_edicels
pedicle1238973p_edicle
pedicles1338683p_edicles
peewits12105873peewi_ts
perfects15107353perfects
peridots1138323peridots
permits11314003permi_ts
persists1049183persists
pewits112810683p_ewi_ts
pietists1038323pietists
pledgets12365673pledgets
plenists1038253plenists
poetics11312073poetic_s
praefects1642883praefects
praelects1354363praelects
preact103220393pre_act_
preadapts1444003preadapts
preadmits1444923preadmits
preadopts1445143preadopts
preadults1244283preadults
preaudits1265023preaudi_ts
prebids12399883prebi_ds
prebills1237293prebills
prebinds13357733prebinds
prebirth1543463prebirth
prebirths1642153prebirths
precasts1239453precasts
precents123015043precents
precepts14268893precepts
precinct1459423precinct_
precious12310593precious
precipes143212213precipes
precis103416703pre__cis
precises123218333precises
precuts111710473pre_cuts
predacity1745603predacity
predate10616893pred_ate
predates11615813predates
predawns1444363predawns
predeath1447003predeath
predeaths1544743predeaths
prededucts1642223prededucts
predial103815413predi_al
predicant1449393predicant
predicated1649143predicated
predicting1649873predicting
prediction15410303prediction
predictions1649653predictions
predictive1847423predictive
predigest1357633predigest
predigests1443663predigests
predive13511083predi_ve
predries112714383predries
predrills1244473predrills
predusks1543423predusks
preedit10512463preedi_t_
preelects1356083preelects
preempts1444543preempts
preenacts1345843preenacts
preerects1345413preerects
preexists1844733preexists
prefaces15311063prefaces
prefect141011073prefect_
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
prefocus1544743prefocus
preheats1339413preheats
prejudices2243053prejudices
prelect111013833prelect_
prelimits1366013prelimits
prelims1139823preli_ms
prelives13310383prelives
premedics1645303premedic_s
premiers122911653premiers
premies113823063premi_es
premises123018273premises
premiss113513813premi_ss
premiums1437533premiums
premixes193110083premixes
premixt183510663premixt_
prentices131111903prentices
prepacks1836583prepacks
preprices1569263preprices
preprints1347473preprints
prepuces1438583prepuces
preriot9316413preriot_
presents103315643presents
presets94216423pre_sets
presides11414913presides
presift12312223presift_
preslices1338213preslices
presorts105311683presorts
prests84021263pre__sts
pretests10310013pretests
pretexts1735603pretexts
prevents133012293prevents
previews1634513previews
previous1337823previous
previses133814283previses
previsits1446793previsits
prewires133811013prewires
prexies163415003prexi_es
prices104524543pr__ices
pricks144414263pr__icks
priedieus1242943priedieus
prints84320103pr__ints
probits112712573probi_ts
produces1347903produces
product1279233product_
profits122911243profi_ts
projects1936413projects
prosects1239473prosects
protects1239743protects
protists10313363protists
pundits10379293pundi_ts
radices102314263_radices
reacts83616603_re_acts
readdicts1343613_readdicts
recits83621353_reci_ts
redact9419043_redact_
redials84416883_redials
redias74523603_redi_as
redips93713843_redi_ps
redipt94116743_redipt_
redirects12125103_redirects
redocks14409933_redocks
redouts81411663_redouts
reduces10513343_reduces
reedits8511743reedi_ts
refects124012743_refects
refits94017653_refi_ts
reindicts1274763_reindicts
rejects163910693_rejects
relics84517903_relic_s
relict83623903_relict_
relists73817053_relists
relucts9369673_relucts
remints95117293_remints
remits85622943_remi_ts
resects94115593_resects
resifts10378703_resifts
resists74414923_resists
resits64725563_resi_ts
retints74717013_retints
verdict1339583verdict_

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.403443402.0
2DLD Change Limit1461621967.39319770.3
3Display Results1961960.0762578.9
 (SQL Overall)1786911967.87222699.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.