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

273 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
prelife127994(None) 
pelite84323002p_elite
perlite9317322perlite
praline93019742praline
precipe133012122precipe
precise113518172precise
predive13511082predive
prefile123413182prefile
prefire124012812prefire
prelate9519692prelate
prelim10311422preli_m
prelims1139822prelims
prelives13310382prelives
prelude1038012prelude
premie103617992premi_e
premise113818552premise
preside10715612preside
presift12312222presift
preslice1258622preslice
previse123713792previse
prewire124311142prewire
proline92321592proline
relief94419682_relief
reline65434352_reline
relive95120782_relive
alewife1344923alewife
apelike13310533apelike
arenite71017713arenite
armlike1348553armlike
beelike13379783beelike
beeline93314723beeline
belie75630383_beli_e
belief115018603_belief
belike124616283_belike
belive115415303_belive
berline93716853berline
birdlife1443483birdlife
creolise1037863creolise
creolize1947183creolize
crevice1436153crevice
delime9314043_delime
elide64922643__elide
elite56230183__elite
eremite9312833eremite
eyelift1396383eyelift
eyelike1436973eyelike
feline94820143_feline
ferlie92814053ferli_e
grecize1935663grecize
greige847203gre_ige
harelike1539613harelike
hoelike141411163hoelike
icelike1337173icelike
life75433733___life
lowlife1335143lowlife
midlife13248303midlife
myeline1238253myeline
nonlife1038553nonlife
obelise9310173obelise
obelize1838243obelize
oreide7311673ore_ide
parklike1337493parklike
pealike131211273pealike
peeling102919873peeling
peerie83617893peeri_e
peglike14136773peglike
peise75825773p_e_ise
pelage9515363p_elage
pele65539553p_el__e
pelf97031453p_el_f_
pelfs105016293p_el_fs
pelisse967063p_elisse
pelites93821993p_elites
penile82219603p_enile
penlite9313243penlite
perdie94718513perdi_e
perlites10316363perlites
petite84320653p_etite
piglike14157313piglike
pinelike14188613pinelike
pipelike16166693pipelike
pipeline12149503pipeline
plie65127393p__li_e
podlike14108553podlike
poetise9314043poetise
poetize18310773poetize
poetlike1436733poetlike
police102918563p_olice
polite83625073p_olite
popelike16177853popelike
potlike13910123potlike
potline91015233potline
praecipe1444633praecipe
praise84419413pr_aise
pralines102217723pralines
prebade12310283prebade
prebake1539093prebake
prebid113512843prebi_d
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
precede1239653precede
precipes143212213precipes
precis103416703preci_s
precised133213413precised
preciser123411663preciser
precises123218333precises
precited133013813precited
preclude1344903preclude
precode12311853precode
precure11312553precure
predate10616893predate
predial103815413predial
predict12315323predict
pree67044733pre___e
preeing103817673preeing
preemie11310563preemie
preface14510923preface
prefade1339013prefade
prefer113813203pre__fer
prefiled143310573prefiled
prefiles133113443prefiles
prefired144310753prefired
prefires134313283prefires
prefix18356853prefi_x
prefixed21357703prefixed
prefixes20389233prefixes
preflame1545913preflame
pregame1239553pregame
preguide1255423preguide
prelacy1437583prelacy
prelates10418573prelates
prelaw1139103prel_aw
prelect111013833prelect
prelimit1259123prelimit
preload1049813preload
preluded1236473preluded
preluder1135733preluder
preludes1137833preludes
prelusive1455583prelusive
premade12311443premade
premier113515633premier
premiere12249233premiere
premies113823063premies
premised133013193premised
premises123018273premises
premiss113513813premiss
premium13310363premium
premix173710333premi_x
premixed20338013premixed
premixes193110083premixes
premixt183510663premixt
premune1138933premune
prename11412643prename
prentice121012353prentice
prepare111913623prepare
prepave14228873prepave
prepill1147583prepill
preplace1488983preplace
preppie1058093preppie
preprice1488873preprice
prepuce1337833prepuce
prerace11414123prerace
prerinse1038633prerinse
preriot9316413preriot
presage10312293presage
presale9416353presale
prese75228383pre__se
presided12410553presided
presider11410423presider
presides11414913presides
presifted1536873presifted
presifts1366593presifts
presliced1435983presliced
preslices1338213preslices
prestige11310733prestige
presume11310303presume
pretape113511623pretape
prettify1644343prettify
pretype14387483pretype
preunite1039573preunite
preview1536473preview
prevised143611073prevised
previses133814283previses
prevue1179163pre_vue
prewired14358473prewired
prewires133811013prewires
prexies163415003prexies
preying133114553preying
price93725413pr__ice
pride84724733pr__ide
prime96525603pr__ime
primine113214823primine
prise74632613pr__ise
prize164718943pr__ize
profile123211153profile
prolate9419793prolate
prole74527793prol__e
prolific1546743prolific
prolines102619693prolines
prolix1538683proli_x
promine112819443promine
promise113415843promise
propine113020213propine
provide1339853provide
puerile9310093puerile
purline93516533purline
purselike1544373purselike
puslike1347563puslike
pyrolize2248133pyrolize
realise73021813_realise
realize162717083_realize
recipe103414893_recipe
recite83625113_recite
recline94020493_recline
rediae74221993_rediae
redline84218833_redline
refile95122373_refile
refine95225693_refine
refire95419473_refire
regime95313943_regime
regive104814323_regive
rehire95415863_rehire
reif76937653_re_if_
reifs84819093_re_ifs
reify114814973_re_ify
reive85522943_re_ive
relace83122153_relace
relate64033633_relate
releve95116403_releve
relic74623363_reli_c
relics84517903_relics
relict83623903_relict
relied74926233_relied
reliefs10439433_reliefs
relier65826183_relier
relies65036423_relies
relieve105010693_relieve
relined85321933_relined
relines75331323_relines
relink104415923_relink
relique1636823_relique
relish93916953_relish
relist64628413_relist
relit55340683_reli_t
relived115114683_relived
relives104619443_relives
relume8313273_relume
remise84221953_remise
repine85627813_repine
rerise64325633_rerise
reside74224933_reside
resift94017723_resift
resile64627673_resile
resite64128453_resite
resize154117723_resize
retie55735303_reti_e
retile65929673_retile
retime85321803_retime
retine66237333_retine
retire64927013_retire
revile94921613_revile
revise94019743_revise
revive124914823_revive
rewire95421413_rewire
rexine134719443_rexine
rife74632323_r__ife
toelike11149823toelike
treelike1237003treelike
uralite71714103uralite
ureide7310363ure_ide
urnlike1136713urnlike
wirelike15167493wirelike

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 Limit1340272737.18618651.1
3Display Results2732730.1102481.8
 (SQL Overall)1786912737.70223200.6
 
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.