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

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

83 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
prohibitionists2272071prohibitionists_
prohibitionist2162422prohibitionist__
exhibitionists2662514_exhibitionists_
prohibitions1953834prohibition___s_
exhibitionisms2882065_exhibitionisms_
exhibitionist2572915_exhibitionist__
exhibitionistic2981405_exhibitionistic
prohibition1854265prohibition_____
prohibitiveness2572265prohibitivenes_s_
projectionists2594115pro_jectionists_
protectionists18105145pro_tectionists_
abolitionists15134226abo__litionists_
coalitionists1583946_co_alitionists_
exhibitionism2762156_exhibitioni__sm
oppositionists18132866oppo__sitionists_
partitionists1554766p__artitionists_
precisionists1754636pr__ecisionists_
primitivists1962546pr__imiti_vists_
prohibiting1953936prohibiti_n____g
projectionist2485256pro_jectionist__
protectionisms2094026pro_tectionisms_
protectionist17116686pro_tectionist__
abolitionisms17153857abo__litionisms_
abolitionist14145137abo__litionist__
abortionists1454997abo___rtionists_
adoptionists1553937ado___ptionists_
associationists17183077associ_ationists_
coalitionist1485507_co_alitionist__
contortionists16103367_contortionists_
cooperationists1963197cooperationists_
coreligionists1761887_coreligionists_
corruptionists1862457_corruptionists_
creationists1476627cr___eationists_
demolitionists1763477_demolitionists_
deviationists17104747_devi_ationists_
divisionists1653277___divisionists_
elocutionists1554317elo__cutionists_
evolutionists16145717evo__lutionists_
exhibitioners2561597_exhibition_ers_
exhibitions2353657_exhibition___s_
fictionists1655997___fi_ctionists_
inhibitions1644827_inhibition___s_
intuitionists1363897__intuitionists_
irreligionists1571767ir_religionists_
isolationists1384657iso__lationists_
nutritionists1393707__nutritionists_
operationists1556057__operationists_
oppositionist17143817oppo__sitionist__
partitionist1456267p__artitionist__
perfectionists2164017p_erfectionists_
philistinisms20112377p__hilisti_nisms_
photobiologists2365177photobiologists_
pointillists1453077p_o_i_ntillists_
positivists1654197p_o__siti_vists_
precisionist1656487pr__ecisionist__
prelibations16127627prelibation___s_
prerevisionist19102527prerevisionist__
primitivisms2162297pr__imiti_visms_
primitivist1853317pr__imiti_vist__
primitivistic2271767pr__imiti_vistic
probabilists1872957pro__babi_lists_
probationers1662577pro__bation_ers_
probations14311087pro__bation___s_
prohibitive2152827prohibit___i__ve
prohibitively2662007prohibit___ively
prohibitory2152577prohibit_o____ry
prohibits1644937prohib_____i_ts_
propitiations1756207propitiation___s_
propositioning1972797propositioni__ng
propositions16108317proposition___s_
protagonists1553687pro___tagonists_
protectionism1984947pro_tectioni__sm
provincialists21122317provi_ncialists_
receptionists1754777_r_eceptionists_
recreationists1664377_recreationists_
reductionists1654667_r_eductionists_
religionists1354397_r__eligionists_
repudiationists18212637_repudiationists_
restrictionists1764087_restrictionists_
revisionists15144817_r__evisionists_
revolutionists17145127_revolutionists_
routinists1046097_ro___uti_nists_
trombonists1553057tro_mb___onists_

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 Filter178691950240.373479064.3
2DLD Change Limit95024838.56311097.0
3Display Results83830.0631317.5
 (SQL Overall)178691838.99919856.8
 
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.