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

186 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
preps9622069(None) 
peeps95822361peeps
peps85134511p_eps
perps95521481perps
prees75937171prees
preops104911941preops
prep86427671prep_
press75425951press
preys105717781preys
props95726881props
reps65937951_reps
apres75426402apre_s
areas55935772areas
arepa75615562arepa
arepas85515702arepas
ares45871022are_s
beeps95320972beeps
brees75632552brees
brens75823362brens
brews105617072brews
ceps86125952_ceps
craps95328642craps
creds85418772creds
creeps104213622creeps
crepe95520722crepe
crepes105419342crepes
crept95125892crept
crepy124812702crepy
cress75022832cress
crews105917502crews
crops96125232crops
deeps84921772deeps
drees65628522drees
dregs76114862dregs
dreks105714752dreks
dress65319832dress
drips85417232drips
drops85719502drops
fraps105620552fraps
frees86131392frees
frets85523402frets
grees65132472grees
greys96614852greys
grips85520132grips
ires45639282ire_s
jeeps144715372jeeps
keeps116020282keeps
keps106027302_keps
kreeps12427412kreeps
neeps75617882neeps
ores46056682ore_s
palps94719562palps
paps86443452p_aps
pareos87023772pareos
parers85530742parers
pares77164482pare_s
pareus85420742pareus
peas65755062p_eas
pecs84634102p_ecs
peds75835242p_eds
peeks115021112peeks
peels75226422peels
peens76428192peens
peep85833692peep_
peers75130272peers
pees65257372p_ees
pegs75531762p_egs
pehs95625762p_ehs
pens65649642p_ens
pep76447082p_ep_
pepo87622152p_epo
pepos96620082p_epos
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perp89029892perp_
pervs105117372pervs
pes57259782p_e_s
pets66248332p_ets
pews95731532p_ews
piers75926332piers
pies66949602pie_s
pimps114616982pimps
pipes96030142pipes
pips85837132p_ips
pleas75627032pleas
plebs95814582plebs
plews105415352plews
plops95920332plops
poems95715552poems
poets76024442poets
pomps115316192pomps
poops94422412poops
popes95933812popes
pops86340952p_ops
pores75849032pore_s
prams96125512prams
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
preamps1336612preamps
precis103416702precis
pree67044732pre_e
preed85128122preed
preen75925052preen
preens85020112preens
preop94715872preop
prepay13310312prepay
prepays1437482prepays
preppy1235522preppy
presa74319042presa
prese75228382prese
prest75736352prest
prests84021262prests
prex135722972pre_x
prexes154915952prexes
prexy174611582prexy
prey96228482pre_y
prez156126312pre_z
prezes173614692prezes
priers84521192priers
pries74339532pries
prigs85219702prigs
primps124711822primps
prims95425932prims
priss74623892priss
proas75028802proas
prods85523552prods
proems104711162proems
profs105120892profs
progs86624152progs
proms95426412proms
prop85932812prop_
pros65742782pr_os
pross76529402pross
prows106327012prows
pryers115012242pryers
pulps95116482pulps
pumps115520602pumps
pups86032232p_ups
purees84721682purees
pyes95528992pye_s
pyres105523882pyre_s
raps66247732_raps
reaps75626192_reaps
rebs65733562_rebs
recs65734182_recs
reds56042862_reds
rees45364192_rees
refs75732242_refs
regs55436572_regs
reis45343232_reis
rems66237722_rems
rep55847802_rep_
repo66027542_repo
repos74725792_repos
repp85418742_repp
repps95114342_repps
res35565042_re_s
rets45352562_rets
revs75027052_revs
rips66237432_rips
seeps74828752seeps
skeps115614252skeps
sprees85620642sprees
steps76619882steps
streps86218062streps
traps75727482traps
trees55835762trees
treks96016852treks
tres46542902tre_s
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
trips74923362trips
ureas55826012ureas
urps66920482ur_ps
veeps104715722veeps
weeps104120562weeps
wraps105617152wraps
wrens85016242wrens
yeps95924402_yeps
zeps156019342_zeps

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.310576422.6
2DLD Change Limit538001861.62633087.3
3Display Results1861860.0632952.4
 (SQL Overall)1786911861.99989390.2
 
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.