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

290 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
purveys1561590(None) 
purvey14559571purvey_
surveys13357571surveys
burleys12479672burleys
curves114619282curve_s
curvets12399912curvets
curvey144111842curvey_
garveys14124462garveys
gurneys11406462gurneys
hurleys13407332hurleys
jarveys20123412jarveys
murreys12367322murreys
parleys125212372parleys
peaveys15324062peaveys
preys105717782p_r_eys
pulleys12399142pulleys
punkeys16366492punkeys
purees84721682pur_ees
purgers104714002purgers
purges94421762purge_s
pursers93916092pursers
purses84826372purse_s
purveyed1743362purveyed
purveyor1641542purveyor
purveyors1741662purveyors
purviews1642532purviews
pusleys12286232pusleys
spurreys13364602spurreys
surreys10489442surreys
survey124111672survey_
turkeys1434522turkeys
turves94212692turve_s
aures55137093aur_e_s
aureus65314883aur_eus
barleys125011843barleys
barneys12569563barneys
burdens1039713burdens
burets84321263bur_ets
burgees104915893burgees
burgers103918573burgers
burgess10409343burgess
buriers94017193buriers
buries84633273burie_s
burkers133716623burkers
burkes124421313burke_s
burlers94120273burlers
burley114715753burley_
burners94115673burners
burnets93813263burnets
burrers93814493burrers
burses84425513burse_s
carneys124310543carneys
carvels124914593carvels
carvers124817543carvers
carves115128453carve_s
conveys15308223conveys
corvees124613793corvees
corves115122523corve_s
corvets124715023corvets
coveys145413503_coveys
culvers12329833culvers
curbers115514383curbers
curers84923193cur_ers
cures75645433cur_e_s
curets84922343cur_ets
curfews15294913curfews
curies84934023curie_s
curlers94218073curlers
curlews12387393curlews
cursers94317163cursers
curses85328273curse_s
curtesy1265833curtesy
curtseys1342743curtseys
curve104920023curve__
curved124815223curve_d
curvet114720243curve_t
curvy136013373curv_y_
cuteys11569983cu_teys
cuvees1139373cu_vees
darkeys15356533darkeys
dures65635923dur_e_s
duress74712063dur_ess
duvets1039223du_vets
furies95126373furie_s
furlers104214223furlers
furless103210143furless
furzes186613693furze_s
garvey13127873garvey_
greys96614853_gr_eys
gulleys11438523gulleys
gurges84716863gurge_s
gurnets84010793gurnets
gurney10429413gurney_
humvees1534683humvees
hunkeys17386193hunkeys
hurlers103714323hurlers
hurley125012523hurley_
hurrays13386153hurrays
hurters103413643hurters
jarvey19135403jarvey_
jerseys1733243jerseys
journeys1843203journeys
jurels133710583jur_els
juries134120633jurie_s
kerseys1433993kerseys
lurers64217493lur_ers
lures56138533lur_e_s
lurkers113910083lurkers
marvels123810093marvels
muleys11409643mu_leys
mulleys12299203mulleys
murders103311363murders
mures75937223mur_e_s
murres85019043murre_s
murrey114312263murrey_
nerves94216193nerve_s
nursers74311833nursers
nurses63919353nurse_s
parcels113712663parcels
pareos87023773par_eos
parers85530743par_ers
pares77164483par_e_s
pareus85420743par_eus
parges94529543parge_s
pargets105215193pargets
paries84742513parie_s
parkers133816873parkers
parlays123910453parlays
parles86334403parle_s
parley116718363parley_
parrels94713493parrels
parsecs11429923parsecs
parsers94118153parsers
parses85534703parse_s
parsleys1335083parsleys
parve109824853parve__
parvenu1247023parvenu
parvenus1335653parvenus
parvis116114803parv_is
parvos116614753parv_os
pavers115021823p_avers
paves104833923p_ave_s
peavey14398793peavey_
peeves113814873peeve_s
pelves114514663pelve_s
peres76246643per_e_s
perses85428063perse_s
perverse1336103perverse
pervert12315583pervert
perverts1337533perverts
pervs105117373perv__s
phoneys15437143phoneys
pinkeys16378213pinkeys
plovers123611833plovers
pogeys124110353p_ogeys
pokeys15529513p_okeys
pooves113914713poove_s
pores75849033por_e_s
porkers134314933porkers
porters93722703porters
pourers93513673pour_ers
prays105022433p_r_ays
preens85020113p_reens
prees75937173p_r_ees
preps96220693p_r_eps
press75425953p_r_ess
presurveys1842543presurveys
prey96228483p_r_ey_
priers84521193p_riers
pries74339533p_rie_s
privets122910053privets
proems104711163p_roems
provers123817793provers
proves114322253prove_s
prudes94215443prude_s
pruners93710723pruners
prunes83419063prune_s
pryers115012243p_ryers
pubes94423403pu_be_s
puces94924633pu_ce_s
puckers153514673puckers
puffers15349203puffers
pugrees10218523pugrees
pukes114523023pu_ke_s
pulers83820283pu_lers
pules74538813pu_le_s
pullers93618483pullers
pullets94015163pullets
pulley113713403pulley_
pulpers114612283pulpers
pulsers94213153pulsers
pulses83818663pulse_s
pummels13236543pummels
pumpers133113673pumpers
punkers133714853punkers
punkey154011173punkey_
punners94114233punners
punnets9409263punnets
punters93617043punters
puppets10317013puppets
puranas9712643puranas
purdahs13285483purdahs
purdas92612263pur_das
pure65543333pur_e__
puree74632843pur_e_e
pureed95017813pur_eed
purely114013633pur_ely
pureness101110183pureness
purer75127903pur_e_r
purest84021933pur_est
purflers13216963purflers
purfles122511843purfles
purge85324603purge__
purged104918263purge_d
purger94717233purge_r
purify14399153purify_
purines94420763purines
purins83722653pur_ins
puris75332023pur__is
purisms114110833purisms
purists94014073purists
purity114114913purity_
purled94520753purle_d
purlieus1034633purlieus
purlins93415423purlins
purls74723353pur__ls
purples112712833purples
purply13369053purply_
purred94218073purre_d
purrs75320433pur__rs
purs65641043pur___s
purse76028893purse__
pursed95220883purse_d
purser85020473purse_r
pursuers10376523pursuers
pursues94111373pursues
pursy105016413pur_sy_
purty105019403pur_ty_
purveying1843573purveying
purview1534233purview
puses75532203pu_se_s
pushers123814503pushers
pushes114621663pushe_s
pusley11379613pusley_
pusses84322843pusse_s
pussleys13273173pussleys
puttees93612913puttees
putters94219193putters
putzes174212523putze_s
pyres105523883pyr_e_s
quavers19309013quavers
queys17398363qu__eys
quivers19298753quivers
resurveys1542683resurveys
servers103214833servers
serves94423653serve_s
slaveys13415203slaveys
spurges104111653spurge_s
spurners10288493spurners
spurrers10338463spurrers
spurrey12307813spurrey_
spurters103311703spurters
surfers103614133surfers
surgers83517483surgers
surges73924593surge_s
surrey94414583surrey_
surveil1045093surveil
surveils1144523surveils
surveyed1544233surveyed
surveyor1442263surveyor
surveyors1542293surveyors
tourneys1134013tourneys
treys85018213_tr_eys
tureens7289873tureens
turkey1337763turkey_
turners73912893turners
turnkeys1542123turnkeys
turrets73010673turrets
upcurves1583153upcurve_s
uprivers13215563uprivers
uraeus638793_uraeus
ureas55826013_ur_eas
urgers73313623_urgers
urges64619913_urge_s
uveas84912283_u_veas
varves124414783varve_s
verves124617883verve_s
vervets13419753vervets
waveys15597013_waveys
wurzels1934083wurzels

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.406440125.6
2DLD Change Limit1340272907.20318607.1
3Display Results2902900.0933118.3
 (SQL Overall)1786912907.70223200.6
 
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.