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

210 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
prefabs143516(None) 
prefab1336241prefab_
preface14510922preface
prefaces15311062prefaces
prefade1339012prefade
prefades1439532prefades
prefers123713332prefers
prepays1437482prepays
rehabs1139022_rehabs
areas55935773are_a_s
arecas84817443areca_s
arenas65021993arena_s
arepas85515703arepa_s
breads95419203bre_ads
breaks124816423bre_aks
breams104815043bre_ams
confabs1435393confabs
crabs95421393cr__abs
creaks124315963cre_aks
creams104715253cre_ams
defats105114553_defats
drabs85119673dr__abs
dreads84115023dre_ads
dreams94513983dre_ams
drears74614253dre_ars
fabs98635863___fabs
freaks134713063fre_aks
grabs85719693gr__abs
greats76318393gre_ats
kebabs14418513_kebabs
oreads73915773ore_ads
paeans85118263pae_ans
paesans93312693paesans
peags86122843p_e_ags
peaks114825623p_e_aks
peals75235493p_e_als
peans75437643p_e_ans
pears75138613p_e_ars
peas65755063p_e_a_s
peats76140193p_e_ats
pecans101515833p_ecans
pedals94316033p_edals
pekans121710553p_ekans
perhaps1446123perhaps
petals84719813p_etals
phreaks1634543phre_aks
pietas84516503pieta_s
pleads94613953ple_ads
pleas75627033ple_a_s
pleats85218593ple_ats
plebs95814583ple__bs
pleiads1045223pleiads
praams10459643pr_aams
prams96125513pr__ams
praos74923563pr__aos
prats76333393pr__ats
praus74621753pr__aus
prays105022433pr__ays
preach133613923pre_ach
preact103220393pre_act
preacts113211363preacts
preamp1238993pre_amp
preamps1336613preamps
prearm104512353pre_arm
prearms11369173prearms
prebade12310283prebade
prebake1539093prebake
prebakes1639013prebakes
prebids12399883prebids
prebuys1444393prebuys
precast11314853precast
precasts1239453precasts
precava1445093precava
precess11310863precess
precis103416703pre_cis
precuts111710473precuts
predate10616893predate
predates11615813predates
predawn1335353predawn
predawns1444363predawns
preens85020113pre_ens
prees75937173pre__es
prefabbed1942323prefabbed
prefaced1638423prefaced
prefacer1537983prefacer
prefacers1636293prefacers
prefaded1537823prefaded
prefect141011073prefect
prefects1598133prefects
prefer113813203pref_er
prefile123413183prefile
prefiles133113443prefiles
prefire124012813prefire
prefires134313283prefires
prefix18356853pref_ix
prefixes20389233prefixes
preflame1545913preflame
prefocus1544743prefocus
preform1439613preform
preforms1537403preforms
prefrank1764233prefrank
prefranks1862993prefranks
prefund1335733prefund
prefunds1454693prefunds
pregame1239553pregame
pregames1339003pregames
preheats1339413preheats
prelacy1437583prelacy
prelate9519693prelate
prelates10418573prelates
prelaw1139103prela_w
prelims1139823prelims
preloads1157513preloads
premade12311443premade
preman104117453prema_n
premeds12389593premeds
premies113823063premies
premiss113513813premiss
prename11412643prename
prenames12311643prenames
preops104911943pre_ops
prepack1757643prepack
prepacks1836583prepacks
prepaid12310133prepaid
prepare111913623prepare
prepares122014163prepares
prepave14228873prepave
prepaves15189193prepaves
prepay13310313prepa_y
preplans1249613preplans
preps96220693pre__ps
prepubes1436053prepubes
prepubis1443643prepubis
prerace11414123prerace
presa74319043presa__
presage10312293presage
presages11312203presages
presale9416353presale
presales10315263presales
presets94216423presets
presoaks1436603presoaks
press75425953pre__ss
presses93523153presses
prestos93716083prestos
prests84021263pre_sts
pretape113511623pretape
pretapes122811533pretapes
pretax152310193preta_x
pretors9316813pretors
prevail1238243prevail
prevails1337663prevails
preverbs15295303preverbs
prevues1239263prevues
prewar114712583prewa_r
prewarm14479613prewarm
prewarms15406733prewarms
prewarn124410153prewarn
prewarns13456943prewarns
prewash1535213prewash
prewraps15114053prewraps
prexes154915953pre_xes
prexies163415003prexies
preyers124412363preyers
preys105717783pre__ys
prezes173614693pre_zes
primas104418103prima_s
proas75028803pr_oa_s
profane122111863profane
profanes132311573profanes
profess1237713profess
profits122911243profits
profs105120893prof__s
prolans9314273prolans
reads64835273_re_ads
reals55038653_re_als
reams75729623_re_ams
reaps75626193_re_aps
rears54739653_re_ars
rebars84019833_rebars
rebs65733563_re__bs
recaps103615733_recaps
redans75421023_redans
redubs9358383_redubs
reface113616353_reface
refaces123216743_refaces
refall94314393_refall
refalls103312243_refalls
refels94618053_refels
refers93921083_refers
refits94017653_refits
reflags1156953_reflags
refs75732243_ref__s
rehab10312443_rehab_
relays94316753_relays
remans84823003_remans
remaps105012873_remaps
repass84114703_repass
repays113813973_repays
resaws93713513_resaws
resays93714153_resays
retags73414303_retags
serdabs1035323serdabs
spreads1039763spre_ads
treads74817923tre_ads
treats64821693tre_ats
trefah1235093trefa_h
trepans92311593trepans
uprears9107493upre_ars
ureas55826013ure_a_s
wreaks134711113wre_aks

Search took 7 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 Limit1340272105.95322514.2
3Display Results2102100.0802625.0
 (SQL Overall)1786912106.43927751.4
 
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.