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
protectionists1810512(None) 
projectionists2594101projectionists
protectionisms2094001protectionisms
protectionist17116651protectionist_
projectionist2485232projectionist_
protectionism1984912protectionis_m
perfectionists2164003perfectionists
protections15510673protection___s
creationists1476594cr__eationists
partitionists1554734part_itionists
perfectionisms2363284perfectionisms
perfectionist2055324perfectionist_
precisionists1754624pr__ecisionists
prohibitionists2272074prohibitionists
projections2258454projection___s
protactiniums1961434protacti_niums
protagonists1553674prot__agonists
protectants1554364protect_an__ts
protection14511454protection____
protectiveness2154584protectivenes_s
protectories1656814protect_ori_es
pyrotechnists23102284pyrotec__hnists
receptionists1754754_receptionists
reductionists1654634_reductionists
selectionists1556014_selectionists
abolitionists15134205abo_litionists
abortionists1454955abo__rtionists
abstractionists19143305abstractionists
adoptionists1553895ado__ptionists
coalitionists1583915_coalitionists
contortionists16103345contortionists
cooperationists1963175cooperationists
corruptionists1862445corruptionists
creationisms1685515cr__eationisms
creationist1379225cr__eationist_
destructionists1894205destructionists
elocutionists1554305elo_cutionists
evolutionists16145705evo_lutionists
extortionists2074375_extortionists
fictionists1655995___fictionists
intuitionists1363875_intuitionists
isolationists1384645iso_lationists
nutritionists1393685_nutritionists
obstructionists19103375obstructionists
operationists1556035__operationists
oppositionists18132865oppo_sitionists
partitionist1456245part_itionist_
perfectionism2253975perfectionis_m
perfectionistic2471905perfectionistic
precisionist1656475pr__ecisionist_
prelections151210445prelection___s
proactions1449335pro_action___s
proctitises15106325pro__cti_tises
proctologists1856805pro__ctologists
productions1647515production___s
prohibitionist2162415prohibitionist_
projection2158755projection____
projectional2355405projection__al
prosecutions1645595prosecution___s
protactinium1861785protacti_ni_um
protagonist1455205prot__agonist_
protectant1446915protect_an__t_
protecting151910205protecti_n___g
protectorate1653515protect_o_rate
protectorates1752865protect_orates
protectors142010125protect_o___rs
protectress1553125protect__res_s
protectresses1762365protect_resses
proteinases1344525prote__i_nases
protestants1354555protest_an__ts
protractions1646615protraction___s
pyrotechnist2282975pyrotec__hnist_
receptionist1656375_receptionist_
recreationists1664365recreationists
reductionisms1853795_reductionisms
reductionist1555985_reductionist_
restrictionists1764085restrictionists
reunionists1154555_r__eunionists
routinists1046075_ro__uti_nists
selectionist1458065_selectionist_
tectonisms1445575___tect_onisms
vivisectionists2371525vivisectionists

Search took 8 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.1261418182.5
2DLD Change Limit95024826.95313666.6
3Display Results82820.0631301.6
 (SQL Overall)178691827.14225019.7
 
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.