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

172 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
purses8482637(None) 
burses84425511burses
curses85328271curses
nurses63919351nurses
parses85534701parses
perses85428061perses
pulses83818661pulses
purees84721681purees
purges94421761purges
purse76028891purse_
pursed95220881pursed
purser85020471purser
pursers93916091pursers
pursues94111371pursues
puses75532201pu_ses
pusses84322841pusses
arses55733872_arses
aures55137092aur_es
birses84717732birses
bourses94014302bourses
buries84633272buries
burkes124421312burkes
bursas85318272bursas
burse75527252burse_
bursts85116242bursts
buses75936012bu_ses
busses85023382busses
carses85233652carses
corses84433462corses
courses94218892courses
cruses88127712cruses
cures75645432cur_es
curies84934022curies
curse75829142curse_
cursed94321252cursed
curser84721472curser
cursers94317162cursers
curves114619282curves
cusses84522772cusses
druses75517252druses
dulses73913652dulses
dures65635922dur_es
duress74712062duress
erses55826802_erses
furies95126372furies
furzes186613692furzes
fuses85628422fu_ses
fusses94920552fusses
gorses74723292gorses
guises74216312guises
gurges84716862gurges
gurshes112210032gurshes
horses94729352horses
hursts97213092hursts
juries134120632juries
lures56138532lur_es
marses84827112marses
mures75937222mur_es
murres85019042murres
muses75134302mu_ses
musses84624782musses
nurse54420122nurse_
nursed74514672nursed
nurser64314502nurser
nursers74311832nursers
opuses84012242opu_ses
pares77164482par_es
pareses94718882pareses
parges94529542parges
paries84742522paries
parises94827192parises
parles86334412parles
parse75236992parse_
parsec105914482parsec
parsecs11429922parsecs
parsed96323892parsed
parser84822372parser
parsers94118152parsers
pases75346502p_ases
passes86030472passes
pauses84621472pauses
peases85229472peases
peises84125042peises
peres76246642per_es
perse75429522perse_
peruses94018162peruses
phases114618402phases
phrases12711462phrases
physes14399782physes
pisses84525082pisses
pluses83618072pluses
plusses93510692plusses
poises84226542poises
pores75849032por_es
poses74642762p_oses
posses85128802posses
prases84429022prases
prees75937172p_rees
press75425952p_ress
pries74339532p_ries
prises84133172prises
proses84733472proses
prudes94215442prudes
prunes83419062prunes
ptoses83514672ptoses
pubes94423402pu_bes
puces94924632pu_ces
pugrees10218522pugrees
puisnes937422puisnes
pukes114523022pu_kes
pules74538812pu_les
pulse74219972pulse_
pulsed94013722pulsed
pulser84215192pulser
pulsers94213152pulsers
purdas92612262purdas
pure65543332pur_e_
puree74632842pur_ee
pureed95017812pureed
purer75127902pur_er
purest84021932purest
purfles122511852purfles
purge85324602purge_
purged104918262purged
purger94717232purger
purgers104714002purgers
purines94420772purines
purins83722652purins
puris75332022pur_is
purisms114110832purisms
purists94014072purists
purled94520752purled
purls74723352pur_ls
purples112712832purples
purposes1237822purposes
purred94218072purred
purrs75320432pur_rs
purs65641042pur__s
pursier94012752pursier
pursiest102812122pursiest
pursue84512252pursue
pursued10388132pursued
pursuer9338892pursuer
pursuers10376522pursuers
pursy105016412purs_y
purvey14559572purvey
purveys15615902purveys
pushes114621662pushes
puss64830132pu_s_s
pussies93615692pussies
putzes174212522putzes
pyoses114314302pyoses
pyres105523882pyr_es
qurshes19228572qurshes
ruses56136582ru_ses
spurges104111652spurges
sudses74114502sudses
surges73924592surges
susses64221052susses
torses64727952torses
turves94212692turves
tusses64921242tusses
upases84112902upases
uprises92012732uprises
urases63723562_urases
urges64619912_urges
uruses63616502_uruses
uses44931112_u_ses
verses94223762verses
worses95522952worses
wursts95211162wursts
wusses93314892wusses

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 Filter178691825510.343520965.0
2DLD Change Limit825511723.39024351.3
3Display Results1721720.0463739.1
 (SQL Overall)1786911723.77947285.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.