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

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

62 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
projections225847(None) 
projection2158761projection_
protections15510701protections
prelections151210472prelections
proactions1449342pro_actions
productions1647532productions
projectiles2243812projectiles
projecting22177242projecti_ng
projectional2355422projectional
projectionist2485252projectionist
projectors21187172project_ors
prosecutions1645612prosecutions
protection14511472protection_
rejections191510102_rejections
trajections2044512trajections
abjections2145673_abjections
bijections21134933_bijections
bolections14137293_bolections
corrections1548873corrections
dejections20168353_dejections
ejections18249963__ejections
erections112515213er__ections
injections1948663_injections
introjections2255783introjections
objections2145633_objections
perfections1848143perfections
predictions1649653predictions
prelection141511293prelection_
preventions1648533preventions
proaction13410103pro_action_
probations14311083pro_bations
processions1548153processions
procreations1647273procreations
production1547893production_
professions1646633professions
progestins1348663progesti_ns
projectile2144553projecti_le
projectionists2594113projectionists
projective2446813projecti_ve
projector20186683project_o_r
projects1936413project___s
prolactins1447153prolacti_ns
promotions1448783pro_motions
pronations12314033pro_nations
proportions1548463proportions
prorations12314463pro_rations
prosecting15189813prosecti_ng
prosectors14199123prosect_ors
prosecution1546073prosecution_
protecting151910213protecti_ng
protectionism1984943protectionism
protectionist17116683protectionist
protectors142010143protect_ors
protractions1646643protractions
provocations1956873provocations
refections151811643_refections
rejection181710253_rejection_
resections121513033_resections
subjections2296353subjections
surjections2075283surjections
trajection1944693trajection_
trisections1345643trisections

Search took 6 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 Filter1786911216330.390458182.1
2DLD Change Limit121633625.39322553.9
3Display Results62620.0302066.7
 (SQL Overall)178691625.81330739.9
 
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.