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 “pasteurises” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
pasteurises134396(None) 
pasteurise1244121pasteurise_
pasteurised1452601pasteurised
pasteurizes2243671pasteurizes
pasteurize2143662pasteurize_
pasteurized2353112pasteurized
pasteurizer2252662pasteurizer
pasteurizers2351772pasteurizers
asterisks1346833_aste_risks
asterisms11511083_aste_risms
auteurisms1244083_auteurisms
auteurists1045093_auteurists
masteries111018513maste_ri_es
passerines1246163passe_rines
pastelists1245803paste_lists
pastellists1353293pastellists
pasteurising1552893pasteurising
pastises103616053past___ises
pastries101517423past__ri_es
pasturages1344923past_urages
pastures10311963past_ur__es
posturists1247073post_urists
wasteries121115363waste_ri_es
amateurisms1552224amateurisms
aneurisms1145634_a_neurisms
aponeuroses1361614aponeuroses
arteries8321514_arte_ri_es
asperses104111674_aspe_r_ses
asterias8317044_aste_ri_as
asterisk1248694_aste_ris_k
asterisked1542914_aste_risked
asterism10413274_aste_ris_m
auteurism1144624_auteuris_m
auteurist946794_auteuris_t
authorises1347584_authorises
bacterizes2347984bacte_rizes
basketries1645054basketri_es
bastardises1473484bastardises
batteries11615134batte_ri_es
bistouries1244474bistouri_es
carburises1445854ca_rburises
cartelises1247684carte_lises
casteisms1345254caste__isms
catechises1744914ca_techises
categorises1454334ca_tegorises
catteries11815554catte_ri_es
cauteries11615404caute_ri_es
cauterizes2198004caute_rizes
earthrises1346824eart_hrises
easterlies1046714easte_rlies
eateries8324324ea_te_ri_es
esterases949634_este_rases
gastritises1253594gastritises
hostelries1345424hostelri_es
hystereses1643804hyste_reses
laterites9715084la_te_rites
laterizes18513034la_te_rizes
listerioses1153754liste_rioses
masseuses1144794masseu__ses
mesmerises1445824mesme_rises
moisturises1353234moist_urises
mysteries141211194myste_ri_es
naturisms1146704na_t_urisms
naturists947514na_t_urists
osteosises1044524_osteosises
palletises1247224palle_tises
pantries101817394pant__ri_es
papeteries1446564papeteri_es
parises94827194pa____rises
parterres1148084parte_r_res
passerine1147084passe_rine_
passuses1036774pas_su__ses
pastelist1149634paste_lis_t
pastellist1255584pastellis_t
pasterns104112624paste_r__ns
pasters94531734paste_r___s
pasteups1243494pasteu___ps
pasteurizing2453394pasteurizing
pasties94529814past___i_es
pastimes123611904past___imes
pastinesses13911724pastinesses
pastnesses12910514past_nesses
pastorales1247144past_orales
pastorates12410164past_orates
pastoriums1445584past_oriums
pasturage1244924past_urage_
pasture9311464past_ur__e_
pastured1138234past_ur__ed
pasturer1037524past_ur__er
pasturers1136394past_ur_ers
pasturing1238434past_uri_ng
patencies1349184pa_tenci_es
patronises1298454pa_tronises
pauperisms1663464paupe_risms
pauperizes2344774paupe_rizes
picturizes2344564pict_urizes
plasterings1444744plaste_rings
pleurisies1243174p__leurisies
postcrisis1454904post_crisis
posteriors1256844poste_riors
posterities1369044poste_rities
postures10313784post_ur__es
posturist11410444post_uris_t
potteries11313604potte_ri_es
pressurises1354654pressurises
preterites12411804prete_rites
proteuses11238994proteu__ses
psalteries1276564psalte_ri_es
pulverises1544484pulve_rises
satirises9410194sa_t_irises
sherrises12156874__sherrises
stearines9311284__stearines
unpasteurized256974unpasteurized
wasterie111211594waste_ri_e_
wastries111212884wast__ri_es
westernises1444204westernises

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit1488191169.09316366.3
3Display Results1161160.0631841.3
 (SQL Overall)1786911169.57918654.5
 
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.