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

259 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
prebuy135742(None) 
prebuys1444391prebuys
rebuy104714681_rebuy
prebid113512842prebid
precut102016532precut
predry1237862predry
prepay13310312prepay
preppy1235522preppy
pretty11510872pretty
prevue1179162prevue
prexy174611572pre_xy
prey96228482pre__y
rebury11349212_rebury
rebus75721112_rebus
rebut75927382_rebut
rebuys11428782_rebuys
trebly1138972trebly
blebby1233743blebby
bready124511183bready
breezy20295853breezy
buy86436543___buy
crabby15346753crabby
creaky154911553creaky
creamy134811363creamy
creasy114612303creasy
creepy13418803creepy
crepey135110933crepey
crepy124812703cre_py
cressy11439113cressy
debug94210063_debug
debut86024143_debut
derby114715343derb_y
drably123511613drably
dreamy12509993dreamy
dreary104611673dreary
drecky16486333drecky
dreggy12364633dreggy
dressy10518143dressy
ephebus1443283ephebus
exequy2542523exequy
feebly1436653feebly
firebug1383793firebug
forebay1538133forebay
foreby1438633foreb_y
freaky16439233freaky
freely12310953freely
frenum1188803frenum
frenzy2135883frenzy
fretty1249223fretty
grabby14336183grabby
greasy10419463greasy
grebe85114943greb_e
grebes93813613grebes
greedy11518843greedy
greeny104811453greeny
gremmy1454473gremmy
grey85624043gre__y
greyly13316543greyly
grubby14324503grubby
herby134715313herb_y
hereby14468333hereb_y
ireful948713ireful
krubut1245553krubut
nebuly1135793_nebuly
orby97519603or_b_y
outbuy1146943outbuy
overbuy1545423overbuy
pageboy1543873pageboy
pareu74928743pare_u_
pareus85420743pare_us
peaky145718153p_eaky
peaty105725693p_eaty
peavy135014843p_eavy
pebbly1545083pebbly
pecky165515093p_ecky
peepul1035783peepul
peery105719443p_eery
penny105119453p_enny
penury1148103p_enury
peony105717563p_eony
peppy114310363p_eppy
perdu84216273perdu_
perdue93912633perdue
perdus93711273perdus
perdy115417323p_erdy
perfumy1763933perfumy
perjury19244253perjury
perky145319483p_erky
peroxy1838243peroxy
perry105222713p_erry
pertly115312543pertly
pesky145911563p_esky
pesty106421713p_esty
petty105320293p_etty
phoebus1443823phoebus
phrensy1533623phrensy
piety105817303pie_ty
plaguy12386413plaguy
pleb86123813pleb__
plebe95014873pleb_e
plebes104313623plebes
plebs95814583pleb_s
plenty11311413plenty
plenum1039503plenum
plexus15377283plexus
poboy121612223p_oboy
poesy105014063poe_sy
poetry1139383poetry
potboy1397813potboy
prahu105013973prahu_
prahus11458243prahus
prau66529473pr_au_
praus74621753pr_aus
pray96331533pr__ay
preach133613923preach
preachy17307313preachy
preact103220393preact
preamp1238993preamp
prearm104512343prearm
prebade12310283prebade
prebake1539093prebake
prebend12319443prebend
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
preboil1148953preboil
prebook1557523prebook
preboom1348243preboom
prebound1345893prebound
prebuild1344303prebuild
prebuilt1247033prebuilt
prebuying1734303prebuying
precis103416703precis
precoup1336123precoup
precure11312553precure
precuts111710473precuts
predusk1443773predusk
pree67044733pre__e
preed85128113pre_ed
preen75925053pre_en
preens85020113preens
prees75937173pre_es
prefab1336243prefab
prefer113813203prefer
prefix18356853prefix
prefund1335733prefund
prelacy1437583prelacy
prelaw1139103prelaw
prelim10311423prelim
prelude1038013prelude
preman104117453preman
premed114617753premed
premen105017803premen
premie103617993premie
premium13310363premium
premix173710333premix
premune1138933premune
preop94715873pre_op
preops104911943preops
prep86427673pre__p
prepays1437483prepays
preps96220693pre_ps
prepuce1337833prepuce
prepupa1064023prepupa
prequel1836343prequel
presa74319043pre_sa
prese75228383pre_se
preset84430983preset
press75425953pre_ss
prest75736353pre_st
presto84216203presto
prests84021263prests
presume11310303presume
pretax152310193pretax
pretor8315743pretor
prevued1337143prevued
prevues1239263prevues
prewar114712573prewar
prex135722973pre__x
prexes154915943prexes
preyed125313193preyed
preyer114413733preyer
preys105717783pre_ys
prez156126313pre__z
prezes173614693prezes
pricey134412633pricey
pricky174210343pricky
pricy124814563pr_icy
primly13439623primly
primus103712173primus
priory114110263priory
prissy11347853prissy
privy13439833pr_ivy
probe94320813prob_e
probed114114823probed
prober104516073prober
probes104119453probes
probit103218353probit
probity14299683probity
progun968783progun
prosy106319253pr_osy
proud84615483pr_oud
proxy175011013pr_oxy
prunus8399363prunus
pry85728053pr___y
pseud867043pse_ud
pueblo1035553pueblo
purely114013613pure_ly
ready94821503_ready
reb55844963_reb__
rebar75420193_rebar
rebbe9313163_rebbe
rebec94416543_rebec
rebel73421293_rebel
rebid85121363_rebid
rebody1238153_rebody
rebop9313283_rebop
rebs65733563_reb_s
rebuff1437023_rebuff
rebuke124010123_rebuke
rebuts84015193_rebuts
recur74116843_recur
recut74729243_recut
redbay1238333_redbay
redbud10135803_redbud
redbug10165473_redbug
redly94217193_redly
redry94314363_redry
redub84212413_redub
redux133811103_redux
reedy910020283_reedy
reefy114217703_reefy
reeky125416263_reeky
refly113914563_refly
refry114412463_refry
reify114814973_reify
rekey124014733_rekey
relay84424673_relay
rely75428953_re_ly
repay104818453_repay
reply104015853_reply
rerun58722153_rerun
resay85320543_resay
retry84718083_retry
revue81114453_revue
ribby12419683_ribby
rubby124413863_rubby
rubus76415053_rubus
ruby97819943_rub_y
sebum93814553_sebum
treaty94414353treaty
treble8311663treble
trembly1435523trembly
trendy10469603trendy
tressy9448553tressy
trey77228793tre__y
webby1537153_webby
zebu153414723_zebu_
zebus164610053_zebus

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162596.03318683.2
3Display Results2592590.0763407.9
 (SQL Overall)1786912596.23228673.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.