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

243 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
predict1231532(None) 
predicts1339611predicts
credit9315192credi_t
edict84722282__edict
preact103220392pre_act
precinct1459422precinct
predial103815412predial
predicant1449392predicant
predicate14411782predicate
predicted1538912predicted
predictor1447092predictor
predive13511082predive
preedit10512462preedi_t
prefect141011072prefect
prelect111013832prelect
premixt183510662premixt
preriot9316412preriot
presift12312222presift
product1279232product
redact9419042_redact
redipt94116742_redipt
relict83623902_relict
verdict1339582verdict
addict10711203_addict
areic73219393are_ic_
benedict1346423benedict
coedit9316243coedi_t
credent10313973credent
credits1039973credits
cretic102816283cretic_
cretics112911653cretics
crevice1436153crevice
deduct10610793_deduct
delict94320333_delict
depict113514793_depict
derelict11138483derelict
dreich12377723dre_ich
edicts94911703__edicts
edit54934863__edi_t
educt85017103__educt
erect74129333ere__ct
evict104417143__evict
herdic123112303herdic_
herdics13249523herdics
indict93115573_indict
irenic8311103irenic_
irenics937833irenics
iridic9328743iridic_
maledict1346673maledict
medic104619653_medic_
medick154010133_medick
medico113711163_medico
medics114115353_medics
pandect12310953pandect
pandit93820753pandi_t
paretic113016673paretic_
paretics122312443paretics
parodic122311723parodic_
parodist11412763parodist
pedant9319493p_edant
pedicab1446693p_edicab
pedicel1237813p_edicel
pedicle1238973p_edicle
peewit111110903peewi_t
perdie94718513perdi_e
perfect141010833perfect
peridot10514243peridot
permit10321683permi_t
persist9315853persist
petit74332653p_eti_t
pewit104622793p_ewi_t
phrenic1438773phrenic_
pietist9414033pietist
pledget113510653pledget
plenist9314333plenist
poetic10416843poetic_
poetics11312073poetics
praedial1178763praedial
praefect1544773praefect
praelect1247533praelect
preach133613923pre_ach
preacts113211363pre_acts
preadapt1346863preadapt
preadmit1346813preadmit
preadopt1348313preadopt
preadult1146973preadult
preaudit1177023preaudi_t
prebid113512843prebi_d
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
prebirth1543463prebirth
prebuilt1247033prebuilt
precast11314853precast
precent113520263precent
precept133112513precept
precincts1544993precincts
precipe133012123precipe
precis103416703preci_s
precise113518173precise
precut102016533pre_cut
predacity1745603predacity
predate10616893predate
predawn1335353predawn
predeath1447003predeath
prededuct1543103prededuct
predicants1546063predicants
predicated1649143predicated
predicates15410823predicates
predicting1649873predicting
prediction15410303prediction
predictive1847423predictive
predictors1547263predictors
predigest1357633predigest
predraft1447593predraft
predried12309573predried
predries112714383predries
predrill1145933predrill
predry1237873pred_ry
predusk1443773predusk
preedits1168763preedits
preeing103817673preeing
preelect1249643preelect
preempt1337723preempt
preenact12410183preenact
preerect1259273preerect
preexist1747963preexist
preface14510923preface
prefects1598133prefects
prefight1746393prefight
prefile123413183prefile
prefire124012813prefire
prefix18356853prefi_x
preheat12413893preheat
prejudice2143343prejudice
prelacy1437583prelacy
prelects1299723prelects
prelife1279943prelife
prelim10311423preli_m
prelimit1259123prelimit
prelims1139823prelims
premedic1546303premedic_
premedics1645303premedics
premeet11615153premeet
premie103617993premi_e
premier113515633premier
premies113823063premies
premise113818553premise
premiss113513813premiss
premium13310363premium
premix173710333premi_x
premolt11312073premolt
prentice121012353prentice
prepack1757643prepack
prepill1147583prepill
preprice1488873preprice
preprint12314183preprint
prepuce1337833prepuce
prerace11414123prerace
prerock1536723prerock
present94022733present
preset84430983pre_set
preside10715613preside
presifts1366593presifts
preslice1258623preslice
presort95219543presort
prest75736353pre__st
pretest9517633pretest
pretext1639663pretext
prevent124016553prevent
preview1536473preview
previse123713793previse
previsit13410073previsit
prewire124311143prewire
prexies163415003prexies
preying133114553preying
price93725413pr__ice
prick134317503pr__ick
pricy124814563pr__icy
priding113317543priding
priedieu1153983priedieu
print74837463pr__int
probit103218353probi_t
prodigy1435573prodigy
produce1267513produce
products1376513products
profit113016273profi_t
project1838453project
prosect11313393prosect
prosit85124593prosi_t
protect11313633protect
protist9320223protist
prudent10310433prudent
prudish1376563prudish
pudic104614563p_udic_
pundit92914183pundi_t
pyemic1537893pyemic_
pyretic143210783pyretic_
pyrexic21235353pyrexic_
pyridic15267833pyridic_
react74634333_re_act
readdict1246153_readdict
recit75235103_reci_t
redacts10510943_redacts
redia65524483_redi_a
rediae74221993_rediae
redial74923113_redial
redias74523603_redias
redid74922393_redi_d
reding83825563_reding
redip87816963_redi_p
redips93713843_redips
redirect11147993_redirect
redock134311543_redock
redout71820253_redout
reduce9713253_reduce
reedit7617223reedi_t
refect114319333_refect
refit84230063_refi_t
regilt71217493_regilt
reindict1187533_reindict
reject154116283_reject
relic74623363_relic_
relics84517903_relics
relicts94414593_relicts
relist64628413_relist
relit55340683_reli_t
reluct83916113_reluct
remint85329973_remint
remit75737223_remi_t
remixt155014853_remixt
resect84424703_resect
resift94017723_resift
resist64524533_resist
resit54241043_resi_t
retint65633443_retint
uredia73610063uredi_a
uredial82910483uredial
uredium1076693uredium
ureic74514463ure_ic_
uremic103410513uremic_
uretic82914353uretic_
verdicts1446013verdicts

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272436.79619721.5
3Display Results2432430.1102209.1
 (SQL Overall)1786912437.31224438.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.