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

149 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
purlieus103463(None) 
purlieu938141purlieu_
hurlies103315332hurlie_s
purlines103514052purlines
purlings113910282purlings
purlins93415422purli_ns
purviews1642532purviews
aureus65314883aur__eus
bullies94121893bullie_s
burdies104117563burdie_s
buriers94017193bur_iers
buries84633273bur_ie_s
burlers94120273burl_ers
burleys12479673burl_eys
burlier93514413burlie_r
burliest103113053burliest
burliness1137833burliness
burnies94017823burnie_s
cullies94419963cullie_s
curies84934023cur_ie_s
curious93813563cur_ious
curlers94218063curl_ers
curlews12387393curl_ews
curlicue1243223curlicue
curlicues1343343curlicues
curlier93314183curlie_r
curliest102713113curliest
curliness1138553curliness
curlings114110383curlings
curriers103410753curriers
curries93723163currie_s
durries83817353durrie_s
euripus934623eur_ipus
ferlies103216693ferlie_s
furies95126373fur_ie_s
furious103110633fur_ious
furlers104214223furl_ers
furless103210143furl_ess
furriers11369483furriers
girlies83013703girlie_s
gullies84717313gullie_s
gurries83515953gurrie_s
hourlies1138343hourlie_s
hurdies114015663hurdie_s
hurlers103714323hurl_ers
hurleys13407333hurl_eys
hurlings12388213hurlings
hurriers11358893hurriers
hurries103919653hurrie_s
juries134120633jur_ie_s
lieus56218483___lieus
milieus939803_milieus
muhlies1238933muhlie_s
murries94118673murrie_s
nucleus956573nucl_eus
outliers82610673outliers
outlies72421993outlie_s
pareus85420743par__eus
paries84742513par_ie_s
parles86334393parl_e_s
parleys125212373parl_eys
parlous9414293parl_ous
parriers103612903parriers
parries93925843parrie_s
partiers103514243partiers
parties93230863partie_s
perilous10310683perilous
peritus9311803per_itus
perlites10316353perlites
perries93226603perrie_s
pervious1337543pervious
pileus84514943p_il_eus
pliers84715153p__liers
plies74526513p__lie_s
polies84034583p_olie_s
popliteus1353073popliteus
porgies103017003porgie_s
porkies133416493porkie_s
priers84521193p_r_iers
pries74339533p_r_ie_s
primus103712173p_r_imus
proteus92511593p_roteus
pruritus1043943pruritus
publics13207143publi_cs
pulers83820283pu_l_ers
pules74538813pu_l_e_s
pulings103511323pu_lings
pulis74225603pu_li__s
pullers93618483pu_llers
pullets94015163pu_llets
pulleys12399143pu_lleys
pulpers114612283pu_lpers
pulpous1177013pu_lpous
pulques1835323pu_lques
pulsers94213153pu_lsers
pulses83818663pu_lse_s
pulvinus1343263pulvinus
punkies134216803punkie_s
punties94520783puntie_s
puppies103212613puppie_s
purees84721683pur__ees
pureness101110183pureness
purflers13216963purflers
purfles122511843purfle_s
purflings1554093purflings
purgers104714003pur_gers
purges94421763pur_ge_s
purgings12347293purgings
purifiers1435873purifiers
purifies13311923purifie_s
purines94420763pur_ines
purins83722653pur_i_ns
puris75332023pur_i__s
purisms114110833pur_isms
purists94014073pur_ists
purities10316283puritie_s
purled94520743purl_e_d
purlin83615863purli__n
purline93516533purli_ne
purling103620293purli_ng
purloiners1242813purloiners
purloins1077033purloins
purls74723353purl___s
purples112712823purple_s
pursers93916093pur_sers
purses84826373pur_se_s
pursier94012753pursie_r
pursiest102812123pursiest
pursiness1138453pursiness
pursuers10376523pursuers
pursues94111373pursue_s
purtier93214093purtie_r
purtiest102414113purtiest
purveys15615903pur_veys
purview1534233purvie_w
pusleys12286233pusl_eys
pussies93615693pussie_s
pusslies1036173pusslie_s
puttiers10288013puttiers
putties94420023puttie_s
spurious1036963spur_ious
spurriers11245063spurriers
spurries102311323spurrie_s
sullies74122223sullie_s
surlier72915443surlie_r
surliest82416903surliest
surliness939943surliness
uglies7412323_uglie_s
uraeus638793_ur_aeus

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621497.86018595.7
3Display Results1491490.0463239.1
 (SQL Overall)1786911498.06222164.6
 
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.