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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
protectionists1810514(None) 
projectionists2594111projectionists
protectionisms2094021protectionisms
protectionist17116681protectionist_
projectionist2485252projectionist_
protectionism1984942protectionis_m
perfectionists2164013perfectionists
protections15510703protection___s
creationists1476624cr__eationists
partitionists1554764part_itionists
perfectionisms2363294perfectionisms
perfectionist2055334perfectionist_
precisionists1754634pr__ecisionists
prohibitionists2272074prohibitionists
projections2258474projection___s
protactiniums1961434protacti_niums
protagonists1553684prot__agonists
protectants1554364protect_an__ts
protection14511474protection____
protectiveness2154594protectivenes_s
protectories1656824protect_ori_es
pyrotechnists23102294pyrotec__hnists
receptionists1754774_receptionists
reductionists1654654_reductionists
selectionists1556024_selectionists
abolitionists15134225abo_litionists
abortionists1454975abo__rtionists
abstractionists19143305abstractionists
adoptionists1553925ado__ptionists
coalitionists1583945_coalitionists
contortionists16103365contortionists
cooperationists1963195cooperationists
corruptionists1862455corruptionists
creationisms1685525cr__eationisms
creationist1379235cr__eationist_
destructionists1894225destructionists
elocutionists1554315elo_cutionists
evolutionists16145715evo_lutionists
extortionists2074385_extortionists
fictionists1655995___fictionists
intuitionists1363895_intuitionists
isolationists1384655iso_lationists
nutritionists1393705_nutritionists
obstructionists19103385obstructionists
operationists1556055__operationists
oppositionists18132865oppo_sitionists
partitionist1456265part_itionist_
perfectionism2253985perfectionis_m
perfectionistic2471905perfectionistic
precisionist1656485pr__ecisionist_
prelections151210475prelection___s
proactions1449345pro_action___s
proctitises15106325pro__cti_tises
proctologists1856815pro__ctologists
productions1647535production___s
prohibitionist2162425prohibitionist_
projection2158765projection____
projectional2355425projection__al
prosecutions1645615prosecution___s
protactinium1861785protacti_ni_um
protagonist1455205prot__agonist_
protectant1446915protect_an__t_
protecting151910215protecti_n___g
protectorate1653515protect_o_rate
protectorates1752865protect_orates
protectors142010145protect_o___rs
protectress1553135protect__res_s
protectresses1762365protect_resses
proteinases1344525prote__i_nases
protestants1354555protest_an__ts
protractions1646645protraction___s
pyrotechnist2282975pyrotec__hnist_
receptionist1656405_receptionist_
recreationists1664375recreationists
reductionisms1853795_reductionisms
reductionist1555995_reductionist_
restrictionists1764085restrictionists
reunionists1154565_r__eunionists
routinists1046095_ro__uti_nists
selectionist1458085_selectionist_
tectonisms1445575___tect_onisms
vivisectionists2371525vivisectionists

Search took 7 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 Filter178691950240.360496363.9
2DLD Change Limit95024826.26615165.0
3Display Results82820.0631301.6
 (SQL Overall)178691826.68926714.2
 
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.