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

443 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
prewar11471258(None) 
prewarm14479611prewarm
prewarn124410151prewarn
prowar114110941prowar
brewer114812552brewer
dewar95817732_dewar
drear65016902dre_ar
pear69745232p_e_ar
prearm104512352pre_arm
prefab1336242prefab
prefer113813202prefer
prelaw1139102prelaw
preman104117452preman
prepare111913622prepare
prepay13310312prepay
presa74319042presa_
pretax152310192pretax
pretor8315752pretor
prewarms15406732prewarms
prewarns13456942prewarns
prewash1535212prewash
prewire124311142prewire
prework164210912prework
preworn124711222preworn
prewrap14104972prewrap
preyer114413732preyer
prower114218122prower
psywar1443322psywar
rear45644552_re_ar
rebar75420192_rebar
rewan85623662_rewan
reward106017642_reward
rewarm115913492_rewarm
rewax155713922_rewax
rewear93012002_rewear
sewar85421102_sewar
uprear8168792upre_ar
alegar739283alegar
anear55420323ane_ar
appear10379343appe_ar
area45843393are_a_
areae55229743are_ae
areal55928733are_al
areas55935773are_as
areaway1335913areaway
areca75618633areca_
arecas84817443arecas
arena55323813arena_
arenas65021993arenas
areolar779223areolar
arepa75615563arepa_
arepas85515703arepas
arrear6310253arrear
bear66844643_be_ar
beware11313713_beware
blear75918683ble_ar
brawer114216333brawer
bread85523113bre_ad
break115319403bre_ak
bream95121813bre_am
brew95023563brew__
brewage1347183brewage
brewed125411873brewed
brewers123811063brewers
brewery15376963brewery
brewis11469983brewis
brews105617073brew_s
briar75718153br_iar
caesar8410933caesar
cedar84014323_cedar
chewer145512623chewer
clear76219053cle_ar
creak115418433cre_ak
cream95721353cre_am
credal9311673credal
crew96122683crew__
crewed125316563crewed
crewel114310483crewel
crewman1435753crewman
crews105917503crew_s
crowbar1444273crowbar
crower114117563crower
dear55343603_de_ar
debar85517863_debar
deewan10267553deewan
denar65223293_denar
dewan95718043_dewan
dewars105117073_dewars
dewax165510853_dewax
drawbar13103193drawbar
drawer104711363drawer
dread74419023dre_ad
dream85120393dre_am
drears74614253dre_ars
dreary104611673dre_ary
drew86221673drew__
ear36867883__e_ar
ewer77523983__ewer
eyebar1135323eyebar
eyewear1342623eyewear
fear75337793_fe_ar
feuar8310243_feuar
fewer115216123_fewer
forewarn14117173forewarn
freak125115243fre_ak
freer86021243fre_er
freeware1446183freeware
freeway1635603freeway
frena85915273frena_
friar85414273fr_iar
froward1436673froward
gear55934973_ge_ar
great66034243gre_at
grew85620263grew__
greyer104510093greyer
grower104614933grower
hear76143883_he_ar
hewer115719933_hewer
jowar155211433_jowar
kebar115113533_kebar
krewe1238193krew_e
krewes1337923krewes
lear47045953_le_ar
leeward1135783leeward
leeway1255883leeway
near45236503_ne_ar
newer85717463_newer
nonwar9159423nonwar
oread64619603ore_ad
outwar91011513outwar
paean77222723pae_an
paesan85114093paesan
palmar104113463palmar
par57467023p___ar
pareira937543pareira
parer75839903pare__r
parkway1934553parkway
partway1535923partway
pawer104422973p_awer
paxwax1742953paxwax
pea56657243p_e_a_
peag75431343p_e_ag
peak106535203p_e_ak
peal68648103p_e_al
pean66147173p_e_an
pearl75324463p_e_arl
pears75138613p_e_ars
peart76440753p_e_art
peas65755063p_e_as
peat65967933p_e_at
pecan91919033p_ecan
pedal86022503p_edal
pedlar93311273pedlar
peeler83517383peeler
peeper103614803peeper
peer66238353p_e_er
peewee11311973peewee
peewit111110903peewit
pekan111613973p_ekan
penal75228373p_enal
per56353093p_e__r
perea75026443perea_
pereia85217983pereia_
perter84422283perter
pesewa1135543pesewa_
pesewas1236223pesewas
petal76526893p_etal
petard95013803p_etard
peter74427593p_eter
pew86442303p_ew__
pewee10319973p_ewee
pewit104622793p_ewit
pews95731533p_ew_s
pewter114013673p_ewter
phew128417113phew__
phreak1536153phre_ak
phylar14437373phylar
piecer105213083piecer
pier66035293pie__r
pieta75421753pieta_
pietas84516503pietas
pilar75221503p_ilar
pillar8314023pillar
planar84212713planar
plea66830603ple_a_
plead85818463ple_ad
pleas75627033ple_as
pleat74734473ple_at
pleiad947833pleiad
plena75816393plena_
plenary1237543plenary
pleura837533pleura
plew97222813plew__
plews105415353plew_s
plexal1536843plexal
plexor1535253plexor
plower114315063plower
polar75623453p_olar
poleward1455943poleward
poplar103611113poplar
postwar1236903postwar
power105325953p_ower
praam94815613pr_aam
praetor938973praetor
pram85733493pr__am
prao66229023pr__ao
prat65952043pr__at
prater84825353prater
prau66529473pr__au
prawn105312433praw_n
prawner1246803prawner
prawns11509023prawns
pray96331533pr__ay
prayer114815293prayer
preach133613923preach
preact103220393preact
preamp1238993preamp
preanal9310713preanal
prearms11369173pre_arms
preaver121011613preaver
prebade12310283prebade
prebake1539093prebake
prebid113512843prebid
preboard1338263preboard
prebuy1357423prebuy
precast11314853precast
precava1445093precava
precis103416703precis
preclear1245423preclear
precure11312553precure
precut102016533precut
predate10616893predate
predator11310053predator
predawn1335353predawn
predial103815413predial
predry1237873predry
pree67044733pre__e
preed85128123pre_ed
preen75925053pre_en
preener93114833preener
preens85020113preens
prees75937173pre_es
prefabs1435163prefabs
preface14510923preface
prefacer1537983prefacer
prefade1339013prefade
prefers123713333prefers
prefire124012813prefire
prefix18356853prefix
preform1439613preform
pregame1239553pregame
preheat12413893preheat
prelacy1437583prelacy
prelate9519693prelate
prelim10311423prelim
preload1049813preload
premade12311443premade
premeal11310523premeal
premed114617763premed
premen105017803premen
premie103617993premie
premier113515633premier
premix173710333premix
premolar1246633premolar
prename11412643prename
preop94715873pre_op
preops104911943preops
preoral9312673preoral
prep86427673pre__p
prepack1757643prepack
prepaid12310133prepaid
prepared132210873prepared
preparer12169643preparer
prepares122014163prepares
prepave14228873prepave
prepays1437483prepays
preplan1149953preplan
preppy1235523preppy
preps96220693pre_ps
prerace11414123prerace
presage10312293presage
presager1138443presager
presale9416353presale
prese75228383pre_se
preset84430983preset
presoak1348453presoak
presort95219543presort
press75425953pre_ss
presser93717623presser
pressor93512883pressor
prest75736353pre_st
prester93519623prester
presto84216203presto
prests84021263prests
pretape113511623pretape
preterm11310163preterm
pretors9316813pretors
pretty11510873pretty
prevail1238243prevail
preverb14317063preverb
prevue1179163prevue
prewarmed17104563prewarmed
prewarned1594773prewarned
prewired14358473prewired
prewires133811013prewires
preworks17599013preworks
prewraps15114053prewraps
prex135722973pre__x
prexes154915953prexes
prexy174611583pre_xy
prey96228483pre__y
preyed125313203preyed
preyers124412363preyers
preys105717783pre_ys
prez156126313pre__z
prezes173614693prezes
pricer103918293pricer
prier75027763pr_ier
prima95019343prima_
primal104014623primal
primary1437703primary
primas104418103primas
primer105118683primer
prior74316173pr_ior
prizer174714883prizer
proa66229963pr_oa_
proas75028803pr_oas
prober104516073prober
procarp1346823procarp
prolan8414693prolan
proper104319953proper
proser84223463proser
prover113819723prover
prow97030383prow__
prowl105615123prow_l
prowler123310013prowler
prowls115511083prowls
prows106327013prow_s
pruner83413453pruner
pruta7314243pruta_
prutah1136583prutah
pryer104415313pr_yer
psywars1533673psywars
pulsar8329363pulsar
purer75127903pure__r
radar61316723_radar
rawer84623733_rawer
read55942533_re_ad
real45750293_re_al
ream65841613_re_am
reap65934743_re_ap
rearm75923573_re_arm
rears54739653_re_ars
rebars84019833_rebars
recap95718023_recap
recur74116843_recur
redan66125013_redan
redear73515173_redear
redware1139363_redware
reearn6612143_reearn
refer84822143_refer
regal65023793_regal
regard85215773_regard
regear73512743_regear
rehab10312443_rehab
rehear93713223_rehear
relax124817803_relax
relay84424673_relay
reman75730153_reman
remap95418103_remap
remark123512373_remark
renal55929513_renal
repair84011463_repair
repark123511713_repark
repay104818453_repay
reran57329103_reran
rereward1246143rereward
resat55139683_resat
resaw84117253_resaw
resay85320543_resay
retag63618413_retag
retard75018933_retard
retax124517973_retax
retear63115483_retear
rewake135218463_rewake
rewards114813993_rewards
rewarms12439603_rewarms
rewash1237673_rewash
rewears102911043_rewears
rewed95425453_rewed
rewet85135153_rewet
rewin85623963_rewin
rewire95421413_rewire
rewon86920583_rewon
reword106321413_reword
rewore938030163_rewore
rework136619793_rework
reworn98122203_reworn
rewrap11127533_rewrap
roar46328573_r_oar
rowan85418733_rowan
rower85430493_rower
screwer124410073screwer
sear47353843_se_ar
sewan85921293_sewan
sewars94018633_sewars
sewer84426223_sewer
shear85424833she_ar
shewer124515113shewer
skewer13519613skewer
smear74416393sme_ar
sowar85821343_sowar
spear75821063spe_ar
spewer115112153spewer
spread9312533spre_ad
stelar64013863stelar
steward1138063steward
strewer104310413strewer
swear85316853swe_ar
tear45242883_te_ar
thenar92610003thenar
tread64821703tre_ad
treat56240353tre_at
trefah1235093trefah
tremor84210403tremor
trepan82511673trepan
trews86118893trew_s
trocar848773trocar
upbear1096493upbe_ar
uprears9107493upre_ars
uproar8106933upr_oar
uptear896783upte_ar
urea46528063ure_a_
ureal56722683ure_al
ureas55826013ure_as
ureter6313203ureter
velar85817633_velar
viewer1237213viewer
war67262423___war
wear75836723_we_ar
wireway1646043wireway
wreak125513273wre_ak
year76534253_ye_ar

Search took 6 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 Filter1786911127160.406440125.6
2DLD Change Limit1127164435.03022408.7
3Display Results4434430.1562839.7
 (SQL Overall)1786914435.59231954.8
 
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.