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

182 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
purse7602889(None) 
burse75527251burse
curse75829141curse
nurse54420121nurse
parse75236991parse
perse75429521perse
pulse74219971pulse
pure65543331pur_e
puree74632841puree
purge85324601purge
purs65641041purs_
pursed95220881pursed
purser85020471purser
purses84826371purses
pursue84512251pursue
pursy105016411pursy
arse46539272_arse
aurae54128112aurae
aures55137092aures
birse74517402birse
bourse84414332bourse
burke115122762burke
burs65847422burs_
bursa74921522bursa
bursae84515602bursae
burses84425512burses
burst75332242burst
carse74934332carse
corse75036182corse
course85117782course
cruse75726102cruse
cure66149122cur_e
cures75645432cures
curie74533042curie
curs65645542curs_
cursed94321252cursed
curser84721472curser
curses85328272curses
curst74931022curst
curve104920022curve
druse64817662druse
dulse65415042dulse
dure56341812dur_e
dures65635922dures
durst66125172durst
furs76735042furs_
furze176815812furze
fuse76429992fu_se
gorse65926812gorse
guise64717712guise
gurge75419782gurge
gursh94512332gursh
horse86132652horse
hurst85527192hurst
lure45142462lur_e
lures56138532lures
marse76231152marse
morse76032702morse
mure65941332mur_e
mures75937222mures
murre74821072murre
muse67136032mu_se
nursed74514672nursed
nurser64314502nurser
nurses63919352nurses
ourie54027302ourie
ours47237562ours_
paise75028332paise
parae76335702parae
pare66760842par_e
pares77164482pares
parge85831852parge
parle75836162parle
pars67560792pars_
parsec105914482parsec
parsed96323892parsed
parser84822372parser
parses85534702parses
parve109824852parve
pase65346862p_ase
passe75525692passe
pause75021832pause
pease75231112pease
peise75825772peise
pere66450262per_e
peres76246642peres
perses85428062perses
peruse84016842peruse
phase104617212phase
phrase11109902phrase
poise75127892poise
pore66451262por_e
pores75849032pores
porose84818742porose
pose66441732p_ose
posse74722272posse
pours74623182pours_
prase76128752prase
pree67044732p_ree
prese75228382prese
prise74632612prise
prose75835122prose
prude84615972prude
prune75119632prune
pubes94423402pubes
pubs85029212pubs_
puce85127882pu_ce
puces94924632puces
puds75630512puds_
pugree92112472pugree
pugs76332772pugs_
puisne856352puisne
puke105025462pu_ke
pukes114523022pukes
pule65040952pu_le
pules74538812pules
puls65437562puls_
pulsed94013722pulsed
pulser84215192pulser
pulses83818662pulses
puns66641482puns_
pupae96515642pupae
pups86032232pups_
pur56840552pur__
purda82914692purda
pureed95017812pureed
purees84721682purees
purer75127902purer
purest84021932purest
purfle112511182purfle
purged104918262purged
purger94717232purger
purges94421762purges
puri65931442pur_i
purin75527592purin
purine85321892purine
puris75332022puris
purism104715062purism
purist85525052purist
purl65631422pur_l
purled94520752purled
purls74723352purls
purple102712682purple
purpose1137382purpose
purr64925812pur_r
purred94218072purred
purrs75320432purrs
pursers93916092pursers
pursier94012752pursier
pursued10388132pursued
pursuer9338892pursuer
pursues94111372pursues
purty105019402purty
purvey14559572purvey
pus55547842pu_s_
puses75532202pu_ses
push95526622pu_sh
puss64830132pu_ss
pusses84322842pusses
pussy105614842pussy
puts65641752puts_
pyre94925552pyr_e
pyres105523882pyres
qursh174110842qursh
ruse45938932ru_se
sparse84516342sparse
spurge93711322spurge
spurs74621522spurs_
sure45447412sur_e
surge65027692surge
terse55026822terse
torse55833332torse
uprise82313692uprise
uprose82311482uprose
urase54624692_urase
urge54722422_urge
ursa44116912_ursa
ursae55214452_ursae
use36835162_u_se
verse84723582verse
worse86525262worse
wurst85122992wurst

Search took 4 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.500357382.0
2DLD Change Limit538001822.61020613.0
3Display Results1821820.0632888.9
 (SQL Overall)1786911823.17356316.1
 
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.