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 “prees” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

330 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
prees7593717(None) 
brees75632551brees
drees65628521drees
frees86131391frees
grees65132471grees
pees65257371p_ees
peres76246641peres
pree67044731pree_
preed85128111preed
preen75925051preen
preens85020111preens
preps96220691preps
prese75228381prese
press75425951press
prexes154915941prexes
preys105717781preys
prezes173614691prezes
pries74339531pries
purees84721681purees
rees45364191_rees
sprees85620641sprees
trees55835761trees
agrees74915322agrees
akees96119242akees
apres75426402apr_es
areas55935772areas
arenes64928392arenes
ares45871022ar_es
aretes64425352aretes
arles56735742arles
arses55733872arses
bees65453382_bees
braes75735052braes
bredes94818472bredes
bree67241262bree_
breed85526692breed
breeds94914882breeds
breeks125310792breeks
brens75823362brens
breves115516422breves
brews105617072brews
bries74942152bries
cees65941592_cees
ceres75540012ceres
creds85418772creds
creed85727392creed
creeds94714772creeds
creek114917392creek
creeks124812922creeks
creel75121482creel
creels84416942creels
creep95218102creep
creeps104213622creeps
creese84014332creese
creesh11328332creesh
cremes104517992cremes
crepes105419342crepes
cress75022832cress
crews105917492crews
cries75438402cries
dees56356632_dees
dree56638322dree_
dreed75222842dreed
dregs76114862dregs
dreks105714742dreks
dress65319832dress
dries64733672dries
epees75219832epees
ernes55224812ernes
erses55826802erses
fees76450602_fees
feres86038182feres
flees85828752flees
free75940182free_
freed95223542freed
freer86021242freer
freers94717302freers
freest95318282freest
freres94716172freres
frets85523402frets
fries85535602fries
froes86126692froes
gees55647882_gees
ghees95215552ghees
glees65027592glees
grebes93813612grebes
gree56641562gree_
greed75125692greed
greeds84314282greeds
greek105915942greek
green65522142green
greens75716872greens
greet65835322greet
greets75117422greets
greys96614852greys
grues65721962grues
heres86245902heres
hirees95117292hirees
ires45639282ir_es
jees115938542_jees
knees95114872knees
kreep114610412kreep
kreeps12427412kreeps
krewes1337922krewes
larees65323112larees
lees45455882_lees
meres75143572meres
ogees65119142ogees
ores46056682or_es
orles55326212orles
paces96741112paces
pages85235072pages
pales75753802pales
panes76148692panes
pareos87023772pareos
parers85530742parers
pares77164482pares
pareses94718872pareses
pareus85420742pareus
parges94529542parges
paries84742512paries
parles86334392parles
parses85534702parses
pases75346502pases
pates76047892pates
paves104833922paves
paxes144928422paxes
payees114812902payees
peas65755062p_eas
pecs84634102p_ecs
pedes85327282pedes
peds75835242p_eds
pee56066512p_ee_
peed76239182p_eed
peek106031432p_eek
peeks115021112peeks
peel65535612p_eel
peels75226422peels
peen65938082p_een
peens76428192peens
peep85833692p_eep
peeps95822362peeps
peer66238352p_eer
peers75130272peers
peeves113814872peeves
pegs75531762p_egs
pehs95625762p_ehs
pekes114623562pekes
peles75738082peles
penes75839222penes
pens65649642p_ens
peps85134512p_eps
pere66450262pere_
perea75026442perea
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
perse75429522perse
perses85428062perses
pervs105117372pervs
pes57259782p__es
pets66248332p_ets
pewees11311392pewees
pews95731532p_ews
pieces104217272pieces
piers75926332piers
pies66949602p_ies
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
pleas75627032pleas
plebes104313622plebes
plebs95814582plebs
plews105415352plews
plexes155313532plexes
plies74526512plies
poems95715552poems
poets76024442poets
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pores75849032pores
poses74642762poses
poxes145325722poxes
prams96125512prams
praos74923562praos
prase76128752prase
prases84429022prases
prates84633162prates
prats76333392prats
praus74621752praus
praxes156215182praxes
prays105022432prays
precess11310862precess
precis103416702precis
prefer113813202prefer
prefers123713332prefers
premed114617752premed
premeds12389582premeds
premen105017802premen
premies113823062premies
preop94715872preop
preops104911932preops
prep86427672pr_ep
presa74319042presa
preset84430982preset
presets94216422presets
presses93523152presses
prest75736352prest
prests84021262prests
pretest9517632pretest
prevues1239262prevues
prex135722972pr_ex
prexies163415002prexies
prexy174611572prexy
prey96228482pr_ey
preyed125313192preyed
preyer114413732preyer
preyers124412362preyers
prez156126312pr_ez
prices104524542prices
prides94324182prides
pried84426862pried
prier75027762prier
priers84521192priers
priest84125422priest
prigs85219702prigs
primes104225262primes
prims95425932prims
prise74632612prise
prises84133172prises
priss74623892priss
prizes173819812prizes
proas75028802proas
probes104119452probes
prods85523552prods
proem94818272proem
proems104711162proems
profs105120892profs
progs86624152progs
proles84627202proles
proms95426402proms
props95726882props
pros65742782pr_os
prose75835122prose
proses84733472proses
pross76529402pross
proves114322252proves
prows106327012prows
prudes94215442prudes
prunes83419062prunes
pryer104415312pryer
pryers115012242pryers
pubes94423402pubes
puces94924632puces
pugrees10218522pugrees
pukes114523022pukes
pules74538812pules
puree74632842puree_
pureed95017802pureed
purges94421762purges
purses84826372purses
puses75532202puses
pyes95528992p_yes
pyrenes123511222pyrenes
pyres105523882pyres
pyrexes19305832pyrexes
pyxes175911402pyxes
rebs65733562_rebs
recs65734182_recs
redes65139122_redes
reds56042862_reds
ree37974072_ree_
reed55549622_reed
reeds65430902_reeds
reef74938212_reef
reefs85121662_reefs
reek85232522_reek
reeks94124032_reeks
reel45240532_reel
reels55333262_reels
reest54938092_reest
refs75732242_refs
reges65628782_reges
regs55436572_regs
reis45343232_reis
rems66237722_rems
reps65937952_reps
res35565042_r_es
rets45352562_rets
revs75027052_revs
rexes124526952_rexes
roes45954132_roes
rues46044482_rues
ryes75529352_ryes
sarees65329942sarees
screes85023962screes
sees45361052_sees
seres55448892seres
sirees64624582sirees
skees95023122skees
spree74830862spree_
sprues84515762sprues
tees45353582_tees
threes97117322threes
tree47745812tree_
treed65626732treed
treen55622752treen
treens65317872treens
treks96016852treks
tres46542902tr_es
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
tries55742812tries
trues54925322trues
tyees86019452tyees
ureas55826012ureas
urges64619912urges
vees75439432_vees
wees76249122_wees
wrens85016242wrens
wries85827742wries
zees136331892_zees

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit538003302.34322962.0
3Display Results3303300.1861774.2
 (SQL Overall)1786913302.62268150.6
 
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.