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

234 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
prefab133624(None) 
prefabs1435161prefabs
preface14510922preface
prefade1339012prefade
prefer113813202prefer
prefix18356852prefix
prelaw1139102prelaw
preman104117452preman
prepay13310312prepay
presa74319042presa_
pretax152310192pretax
prewar114712582prewar
rehab10312442_rehab
trefah1235092trefah
area45843393are_a_
areae55229743are_ae
areal55928733are_al
areas55935773are_as
areca75618633areca_
arecas84817443arecas
arena55323813arena_
arenas65021993arenas
arepa75615563arepa_
arepas85515703arepas
bread85523113bre_ad
break115319403bre_ak
bream95121813bre_am
confab1347063confab
crab85727673cr__ab
creak115418433cre_ak
cream95721353cre_am
credal9311673credal
defat95426693_defat
drab76226453dr__ab
dread74419023dre_ad
dream85120393dre_am
drear65016903dre_ar
fab87453133___fab
freak125115243fre_ak
frena85915273frena_
grab75427613gr__ab
great66034243gre_at
ireful948713ireful
kebab134312003_kebab
oread64619603ore_ad
paean77222723pae_an
paesan85114093paesan
pea56657243p_e_a_
peag75431343p_e_ag
peak106535203p_e_ak
peal68648103p_e_al
pean66147173p_e_an
pear69745233p_e_ar
peas65755063p_e_as
peat65967933p_e_at
pecan91919033p_ecan
pedal86022503p_edal
pekan111613973p_ekan
penal75228373p_enal
perea75026443perea_
pereia85217983pereia_
petal76526893p_etal
phreak1536153phre_ak
pieta75421753pieta_
pietas84516503pietas
plea66830603ple_a_
plead85818463ple_ad
pleas75627033ple_as
pleat74734473ple_at
pleb86123813ple__b
pleiad947833pleiad
plena75816393plena_
plexal1536843plexal
praam94815613pr_aam
pram85733493pr__am
prao66229023pr__ao
prat65952043pr__at
prau66529473pr__au
pray96331533pr__ay
preach133613923preach
preact103220393preact
preamp1238993preamp
preanal9310713preanal
prearm104512353prearm
prebade12310283prebade
prebake1539093prebake
prebid113512843prebid
prebuy1357423prebuy
precast11314853precast
precava1445093precava
precis103416703precis
precut102016533precut
predate10616893predate
predawn1335353predawn
predial103815413predial
predry1237873predry
pree67044733pre__e
preed85128123pre_ed
preen75925053pre_en
preens85020113preens
prees75937173pre_es
prefabbed1942323prefabbed
prefaced1638423prefaced
prefacer1537983prefacer
prefaces15311063prefaces
prefaded1537823prefaded
prefades1439533prefades
prefect141011073prefect
prefers123713333prefers
prefile123413183prefile
prefire124012813prefire
prefixal2044543prefixal
preflame1545913preflame
preform1439613preform
prefrank1764233prefrank
prefund1335733prefund
pregame1239553pregame
preheat12413893preheat
prelacy1437583prelacy
prelate9519693prelate
prelim10311423prelim
preload1049813preload
premade12311443premade
premeal11310523premeal
premed114617763premed
premen105017803premen
premie103617993premie
premix173710333premix
prename11412643prename
preop94715873pre_op
preops104911943preops
preoral9312673preoral
prep86427673pre__p
prepack1757643prepack
prepaid12310133prepaid
prepare111913623prepare
prepave14228873prepave
prepays1437483prepays
preplan1149953preplan
preppy1235523preppy
preps96220693pre_ps
prerace11414123prerace
presage10312293presage
presale9416353presale
prese75228383pre_se
preset84430983preset
presoak1348453presoak
press75425953pre_ss
prest75736353pre_st
presto84216203presto
prests84021263prests
pretape113511623pretape
pretor8315753pretor
pretty11510873pretty
prevail1238243prevail
preverb14317063preverb
prevue1179163prevue
prewarm14479613prewarm
prewarn124410153prewarn
prewash1535213prewash
prewrap14104973prewrap
prex135722973pre__x
prexes154915953prexes
prexy174611583pre_xy
prey96228483pre__y
preyed125313203preyed
preyer114413733preyer
preys105717783pre_ys
prez156126313pre__z
prezes173614693prezes
prima95019343prima_
primal104014623primal
primas104418103primas
proa66229963pr_oa_
proas75028803pr_oas
prof96134663prof__
profane122111863profane
profit113016273profit
profs105120893prof_s
prolan8414693prolan
prowar114110943prowar
pruta7314243pruta_
prutah1136583prutah
read55942533_re_ad
real45750293_re_al
ream65841613_re_am
reap65934743_re_ap
rear45644553_re_ar
reb55844963_re__b
rebar75420193_rebar
recap95718023_recap
redan66125013_redan
redub84212413_redub
ref66053293_ref__
reface113616353_reface
refall94314393_refall
refed93921923_refed
refel84920813_refel
refer84822143_refer
refit84230063_refit
refix155212483_refix
reflag1098083_reflag
refly113914563_refly
refry114412463_refry
refs75732243_ref_s
reft75141273_ref_t
regal65023793_regal
rehabs1139023_rehabs
relax124817803_relax
relay84424673_relay
reman75730153_reman
remap95418103_remap
renal55929503_renal
repay104818453_repay
reran57329103_reran
resat55139683_resat
resaw84117253_resaw
resay85320543_resay
retag63618413_retag
retax124517973_retax
rewan85623663_rewan
rewax155713923_rewax
serdab937833serdab
spread9312533spre_ad
terefah1344113terefah
tread64821703tre_ad
treat56240353tre_at
tref77030993tref__
trepan82511673trepan
uprear8168793upre_ar
urea46528063ure_a_
ureal56722683ure_al
ureas55826013ure_as
wreak125513273wre_ak

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.373479064.3
2DLD Change Limit1127162345.51620434.4
3Display Results2342340.0802925.0
 (SQL Overall)1786912345.96929936.5
 
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.