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

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

45 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
processioned175397(None) 
procession1448412procession__
processional1665392processional
processions1548152procession_s
accessioned1652503_accessioned
precession1448823precession__
precessional1655123precessional
precessions1548553precession_s
pretensioned1553593pretensioned
processed1446803process___ed
processible1754003processible_
processing15108183processi_n_g
processionals1754143processionals
processioning1853743processioning
profession1546593profession__
professional1754963professional
professions1646633profession_s
provisioned1753973pro_visioned
concessioner1653674concessioner
occasioned1572154__occasioned
pensioned1246654p___ensioned
preassigned1552604pr_eassigned
precensored1653144precens_ored
precessed1437524precess___ed
precessing1598744precessi_n_g
predestined1545184predesti_ned
previsioned1744264pr_evisioned
processable1753044processable_
processer1346894process___er
processes13310234process___es
processionally2163134processionally
processor1346234process_o__r
processors1446434process_o_rs
professed1545244profess___ed
professing16106624professi_n_g
professionals1864044professionals
progression1455884progression__
progressional1663964progressional
progressions1555554progression_s
proportioned1754404proportioned
propositioned1853914propositioned
provisioner1653794pro_visioner
recession1149104_recession__
recessional1354984_recessional
recessions1248934_recession_s

Search took 9 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 Filter1786911247900.423422437.4
2DLD Change Limit124790457.75016101.9
3Display Results45450.0331363.6
 (SQL Overall)178691458.20621775.7
 
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.