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

165 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
prelacy143758(None) 
preach133613922pre_ach
preachy17307312pre_achy
preact103220392pre_act
preface14510922preface
prelate9519692prelate
prelaw1139102prela_w
prelect111013832prelect
prepack1757642prepack
prepay13310312prepa_y
preplace1488982preplace
prerace11414122prerace
primacy1635602primacy
privacy1744232privacy
relace83122152_relace
relay84424672_rela_y
areally10411243areally
belady12489933_belady
belay105021523_bela_y
breach134213723bre_ach
bready124511183bre_ady
creaky154911553cre_aky
creamy134811363cre_amy
creasy114612303cre_asy
delay94820633_dela_y
dreamy12509993dre_amy
dreary104611673dre_ary
fallacy1536433fallacy
forelady1545073forelady
freaky16439233fre_aky
greasy10419463gre_asy
kreplach1942613kreplach
lacy95829633___lacy
legacy1256653_legacy
pacy115328683p___acy
palace104516913p_alace
papacy1547493p_apacy
parlay113713993parla_y
peace95026083p_e_ace
peach125422493p_e_ach
peachy164510843p_e_achy
peaky145718153p_e_aky
peaty105725693p_e_aty
peavy135014843p_e_avy
pedlary13277543pedlary
pelage9515363p_elage
peltry11288653p_eltry
piracy1339473p_iracy
place94824613p__lace
plack135017843p__lack
platy105021663p__laty
play95928983p__la_y
pleach134211243ple_ach
plenary1237543plenary
policy133211513p_olicy
pollack1567333pollack
potlach14106363potlach
praelect1247533praelect
pray96331533pr__a_y
preacts113211363pre_acts
preamp1238993pre_amp
prearm104512353pre_arm
prebade12310283prebade
prebake1539093prebake
prebuy1357423pre_buy
precast11314853precast
precava1445093precava
predacity1745603predacity
predate10616893predate
predawn1335353predawn
predict12315323predict
predry1237873pre_dry
preelect1249643preelect
preenact12410183preenact
prefab1336243prefa_b
prefabs1435163prefabs
prefaced1638423prefaced
prefacer1537983prefacer
prefaces15311063prefaces
prefade1339013prefade
prefect141011073prefect
preflame1545913preflame
pregame1239553pregame
pregnancy1744063pregnancy
prelacies13310053prelacies
prelates10418573prelates
prelatic12311283prelatic
prelaunch1642153prelaunch
prelects1299723prelects
prelife1279943prelife
prelim10311423prel_im
prelims1139823prelims
preload1049813preload
preloads1157513preloads
prelude1038013prelude
prelunch1543433prelunch
premade12311443premade
preman104117453prema_n
prename11412643prename
prepacks1836583prepacks
prepaid12310133prepaid
prepare111913623prepare
prepave14228873prepave
prepays1437483prepays
preplaced1676483preplaced
preplaces1578753preplaces
preplan1149953prepla_n
preplans1249613preplans
preplant12712913preplant
preppy1235523pre_ppy
prepuce1337833prepuce
prerock1536723prerock
presa74319043presa__
presage10312293presage
presale9416353presale
preslice1258623preslice
pretape113511623pretape
pretax152310193preta_x
pretty11510873pre_tty
prevail1238243prevail
prewar114712583prewa_r
prewarm14479613prewarm
prewarn124410153prewarn
prewash1535213prewash
prexy174611583pre__xy
prey96228483pre___y
pricy124814563pr__icy
primary1437703primary
prolan8414693prola_n
prolans9314273prolans
prolate9419793prolate
purely114013633purel__y
racy95825683_r__acy
reach105123883_re_ach
react74634333_re_act
ready94821503_re_ady
really93315613_really
realty92713693_realty
redact9419043_redact
reface113616353_reface
relaced103517213_relaced
relaces93420883_relaces
relaid75518443_relaid
reland75920433_reland
relate64033633_relate
relax124817803_rela_x
relays94316753_relays
relic74623363_relic_
relics84517903_relics
relict83623903_relict
relock124713523_relock
reluct83916113_reluct
rely75428953_rel__y
repack142412163_repack
repay104818453_repa_y
replace113214283_replace
replay113412923_repla_y
rerack122513163_rerack
resay85320543_resa_y
retack122612823_retack
supremacy1843053supremacy
treacly1237093tre_acly
treaty94414353tre_aty
upreach1444693upre_ach
virelay1335943virela_y

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.436409841.7
2DLD Change Limit1340271656.75019855.9
3Display Results1651650.0463587.0
 (SQL Overall)1786911657.23224708.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.