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

294 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
predive1351108(None) 
khedive1842502khedive
perdie94718512perdi_e
precipe133012122precipe
precise113518172precise
predate10616892predate
predial103815412predial
predict12315322predict
prefile123413182prefile
prefire124012812prefire
prelife1279952prelife
prelives13310382prelives
premie103617992premi_e
premise113818552premise
prepave14228872prepave
preside10715612preside
previse123713792previse
prewire124311142prewire
rediae74221992_rediae
redrive112410562_redrive
regive104814322_regive
reive85522942_re_ive
relive95120782_relive
revive124914822_revive
aedile73716653_aedile
aedine73218393_aedine
archive154610483archive
arenite71017713arenite
arrive91311793ar_rive
beehive1554033beehive
belive115415303_belive
brede85520503bred__e
breve105317053bre__ve
chedite1338863chedite
creative132812803creative
credible1346023credible
credit9315193credi_t
credited1238253credited
credits1039973credits
crescive1545283crescive
crevice1436153crevice
derive103817043_derive
dive85634783___dive
dredge9308563dred_ge
drive95318003dr__ive
edile64819493__edile
endive103310473_endive
erective13311833erective
eremite9312833eremite
erosive1039203erosive
erudite838483erudite
gradine93317033gradine
greave104611493gre_ave
grecize1935663grecize
greige847203gre_ige
khedives1942183khedives
mediae94217413_mediae
nosedive1243993nosedive
orective1339353orective
oreide7311673ore_ide
paradise112113873paradise
pardie96021443pardi_e
pardine103616733pardine
pareve114613013pare__ve
passive12239593passive
pedate93117763p_edate
peddle103512823p_eddle
pedicel1237813p_edicel
pedicle1238973p_edicle
peerie83617893peeri_e
peeve104915253p_e_eve
peise75825773p_e_ise
pelite84323003p_elite
penile82219603p_enile
pensive122610393pensive
perceive1546973perceive
perdue93912633perd_ue
perdure10379623perdure
perlite9317323perlite
petite84320653p_etite
pledge10469493pled_ge
pledgee11359633pledgee
plosive1236673plosive
podite93315353p_odite
poetise9314043poetise
poetize18310773poetize
postdive1445763postdive
praecipe1444633praecipe
praedial1178763praedial
praise84419413pr_aise
praline93019743praline
preaver121011613pre_aver
prebade12310283prebade
prebake1539093prebake
prebid113512843prebi_d
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
precative16312573precative
precava1445093precava
precavae1544813precavae
precede1239653precede
precipes143212213precipes
precis103416703preci_s
precised133213413precised
preciser123411663preciser
precises123218333precises
precited133013813precited
precode12311853precode
precure11312553precure
predated12513273predated
predates11615813predates
predawn1335353predawn
predefine1546173predefine
predicate14411783predicate
predicted1538913predicted
predictive1847423predictive
predicts1339613predicts
predigest1357633predigest
predinner1245133predinner
predried12309573predried
predries112714383predries
predrill1145933predrill
predry1237873pred_ry
predusk1443773predusk
pree67044733pre___e
preedit10512463preedi_t
preedited1337633preedited
preedits1168763preedits
preeing103817673preeing
preemie11310563preemie
preface14510923preface
prefade1339013prefade
prefiled143310573prefiled
prefiles133113443prefiles
prefired144310753prefired
prefires134313283prefires
prefix18356853prefi_x
prefixed21357703prefixed
prefixes20389233prefixes
pregame1239553pregame
preguide1255423preguide
prejudice2143343prejudice
prelate9519693prelate
prelim10311433preli_m
prelims1139823prelims
prelude1038013prelude
prelusive1455583prelusive
premade12311443premade
premier113515633premier
premiere12249233premiere
premies113823063premies
premised133013193premised
premises123018273premises
premiss113513813premiss
premium13310363premium
premix173710333premi_x
premixed20338013premixed
premixes193110083premixes
premixt183510663premixt
premune1138933premune
prename11412643prename
prentice121012353prentice
prepare111913623prepare
prepaved16177233prepaved
prepaves15189193prepaves
prepill1147583prepill
preppie1058093preppie
preprice1488873preprice
prepuce1337833prepuce
prerace11414123prerace
prerinse1038633prerinse
preriot9316413preriot
presage10312293presage
presale9416353presale
prese75228383pre__se
preserve13108803preserve
presided12410553presided
presider11410423presider
presides11414913presides
presift12312223presift
preslice1258623preslice
presolve1347073presolve
prestige11310733prestige
presume11310303presume
pretape113511623pretape
pretype14387483pretype
preunite1039573preunite
preview1536473preview
prevised143611073prevised
previses133814283previses
prevue1179163pre_vue
prewired14358473prewired
prewires133811013prewires
prexies163415003prexies
preying133114553preying
price93725413pr__ice
pride84724743pr__ide
priding113317543priding
priedieu1153983priedieu
prime96525603pr__ime
primine113214823primine
prise74632613pr__ise
privet113821343pr__ivet
privy13439833pr__ivy
prize164718943pr__ize
prodigy1435573prodigy
produce1267513produce
profile123211153profile
proline92321593proline
promine112819443promine
promise113415843promise
propine113020213propine
prove104823193pr__ove
provide1339853provide
prude84615973prud__e
prudish1376563prudish
puerile9310093puerile
pyridine1447743pyridine
reave84528023_re_ave
receive1239733_receive
recipe103414893_recipe
recite83625113_recite
redate74124683_redate
reddle83815913_reddle
rede55037683_red__e
redeye103811793_redeye
redia65524483_redi_a
redial74923113_redial
redias74523603_redias
redid74922393_redi_d
reding83825563_reding
redip87816963_redi_p
redips93713843_redips
redipt94116743_redipt
redivide1355933_redivide
redline84218833_redline
redone74820053_redone
redriven12226153_redriven
redrives122610393_redrives
redrove11249423_redrove
reduce9713253_reduce
redye94413473_red_ye
reeve84121323_re_eve
refile95122373_refile
refine95225693_refine
refire95419473_refire
regave104713383_regave
regime95313943_regime
regiven11478323_regiven
regives115014213_regives
rehire95415863_rehire
reived104518133_re_ived
reiver95318293_re_iver
reives95723043_re_ives
releve95116403_releve
relieve105010693_relieve
reline65434353_reline
relived115114683_relived
relives104619443_relives
remise84221953_remise
remove116115573_remove
repave114813873_repave
repine85627813_repine
rerise64325633_rerise
reside74224933_reside
resile64627673_resile
resite64128453_resite
resize154117723_resize
restive10315933_restive
retie55735303_reti_e
retile65929673_retile
retime85321803_retime
retine66237333_retine
retire64927013_retire
revile94921613_revile
revise94019743_revise
revived144211653_revived
reviver134411373_reviver
revives134715543_revives
rewire95421413_rewire
rewove126420083_rewove
rexine134719443_rexine
rive75537733_r__ive
sedile73517233_sedile
skydive1852773skydive
tardive1136893tardive
treddle936433treddle
updive1234903_updive
uredia73610063uredi_a
uredial82910483uredial
uredium1076693uredium
ureide7310363ure_ide
uridine81311213uridine

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 Limit1340272947.26618445.8
3Display Results2942940.1102672.7
 (SQL Overall)1786912947.78222962.1
 
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.