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

129 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
pursy10501641(None) 
purs65641041purs_
purse76028891purse
purty105019401purty
pussy105614841pussy
burly104922832burly
burry105221562burry
burs65847422burs_
bursa74921522bursa
burse75527252burse
burst75332242burst
bury95633592bur_y
busy94727172bu_sy
curdy115916522curdy
curly105321232curly
curry105920342curry
curs65645542curs_
curse75829142curse
curst74931022curst
curtsy1156642curtsy
curvy136013372curvy
durst66125172durst
fubsy13589272fubsy
furry116719282furry
furs76735042furs_
fury107727972fur_y
furzy2010116062furzy
fussy115613952fussy
gorsy95915782gorsy
gurry94515412gurry
gursh94512332gursh
gussy95314322gussy
gutsy96412842gutsy
horsy116318392horsy
hurly115819292hurly
hurry114917182hurry
hurst85527192hurst
hussy116812762hussy
jury146719592jur_y
murky145216682murky
murry105120232murry
mussy104117642mussy
nurse54420122nurse
nutsy85711502nutsy
ours47237562ours_
palsy105417462palsy
pansy105717972pansy
pardy115523952pardy
parry105323752parry
pars67560792pars_
parse75236992parse
party106630612party
patsy105717202patsy
perdy115417322perdy
perky145319482perky
perry105222712perry
perse75429522perse
poesy105014062poesy
popsy125713402popsy
porgy116916122porgy
porky145019332porky
porny106020192porny
posy96028422p_osy
potsy105815612potsy
pours74623182pours_
pray96331532p_ray
prey96228482p_rey
prosy106319252prosy
pry85728052p_r_y
pubs85029212pubs_
pudgy124911162pudgy
puds75630512puds_
puffy164410752puffy
puggy124612322puggy
pugs76332772pugs_
pulpy124612362pulpy
puls65437562puls_
pulse74219972pulse
punky144419392punky
punny104217712punny
puns66641482puns_
punty106021612punty
puny95526992pu_ny
puppy114912412puppy
pups86032232pups_
pur56840552pur__
purda82914692purda
pure65543332pur_e
puree74632842puree
purely114013612purely
purer75127902purer
purest84021932purest
purge85324602purge
puri65931442pur_i
purify14399152purify
purin75527592purin
puris75332022puris
purism104715062purism
purist85525052purist
purity114114912purity
purl65631422pur_l
purls74723352purls
purply13369042purply
purr64925812pur_r
purrs75320432purrs
pursed95220882pursed
purser85020472purser
purses84826372purses
pursily1238212pursily
pursue84512252pursue
purvey14559572purvey
pus55547842pu_s_
push95526622pu_sh
pushy134614352pushy
puss64830132pu_ss
pussly11407372pussly
puts65641752puts_
putty104721402putty
qursh174110842qursh
spurry11429112spurry
spurs74621522spurs_
sudsy95010682sudsy
surfy115319472surfy
surgy95118522surgy
surly85124422surly
turfy114315402turfy
ursa44116902_ursa
wurst85122992wurst
wussy115810342wussy

Search took 2 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 Limit538001291.56334421.0
3Display Results1291290.0304300.0
 (SQL Overall)1786911291.686105985.2
 
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.