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

66 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
projectionists259411(None) 
projectionist2485251projectionist_
protectionists18105141protectionists
protectionisms2094022protectionisms
protectionist17116682protectionist_
perfectionists2164013perfectionists
projections2258473projection___s
protectionism1984943protectionis_m
creationists1476624cr__eationists
perfectionisms2363294perfectionisms
perfectionist2055334perfectionist_
precisionists1754634pr__ecisionists
prohibitionists2272074prohibitionists
projection2158764projection____
projectional2355424projection__al
protections15510704protection___s
receptionists1754774_receptionists
reductionists1654654_reductionists
selectionists1556024_selectionists
abolitionists15134225abo_litionists
abortionists1454975abo__rtionists
adoptionists1553925ado__ptionists
coalitionists1583945_coalitionists
cooperationists1963195cooperationists
corruptionists1862455corruptionists
creationisms1685525cr__eationisms
creationist1379235cr__eationist_
elocutionists1554315elo_cutionists
evolutionists16145715evo_lutionists
fictionists1655995___fictionists
isolationists1384655iso_lationists
objectivists2663385_objecti_vists
operationists1556055__operationists
oppositionists18132865oppo_sitionists
partitionists1554765p_artitionists
perfectionism2253985perfectionis_m
perfectionistic2471905perfectionistic
precisionist1656485pr__ecisionist_
prelections151210475prelection___s
proactions1449345pro_action___s
proctitises15106325pro__cti_tises
proctologists1856815pro__ctologists
productions1647535production___s
prohibitionist2162425prohibitionist_
projectiles2243805project___iles
projecting22177245projecti_n___g
projectors21187175project_o___rs
prosecutions1645615prosecution___s
protactiniums1961435protacti_niums
protagonists1553685pro__tagonists
protectants1554365protect_an__ts
protection14511475protection____
protectiveness2154595protectivenes_s
protectories1656825protect_ori_es
pyrotechnists23102295pyrotec__hnists
receptionist1656405_receptionist_
recreationists1664375recreationists
reductionisms1853795_reductionisms
reductionist1555995_reductionist_
rejections191510105_rejection___s
reunionists1154565_r__eunionists
routinists1046095_ro__uti_nists
selectionist1458085_selectionist_
subjectivists27193375subjecti_vists
trajections2044515trajection___s
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.360496363.9
2DLD Change Limit95024666.68614212.4
3Display Results66660.0461434.8
 (SQL Overall)178691667.09225196.1
 
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.