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

35 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
speechifies215220(None) 
speechified2251951speechified
specifies1647572sp_ec_ifies
frenchifies2252863frenchifies
preachifies2153683preachifies
specifics1843933sp_ec_ifics
specified1746253sp_ec_ified
specifier1645683sp_ec_ifier
specifiers1743803sp_ec_ifiers
speeches1537413speech___es
speechify2251933speechif__y
speechifying2651663speechifying
frenchified2352464frenchified
kitschifies235934kitschifies
objectifies2553344objectifies
opacifies1645464op_ac_ifies
pacifies15311224_p_ac_ifies
petrifies14310364_p_etrifies
preachified2273094preachified
prettifies1545694_prettifies
rectifies14310814__rectifies
reedifies1347324_ree_difies
repacifies1745654repac_ifies
respecifies1853724resp_ec_ifies
sanctifies1554984s_anctifies
silicifies1544824silic_ifies
solemnifies1672334solemnifies
speciates13229234sp_ec_iates
species11314134sp_ec___ies
specific1744704sp_ec_ifi_c
speechless1742324speech_less
speechwriter22111224speechwriter
speechwriters23101174speechwriters
stellifies1344314s_tellifies
supercities15411564superc_ities

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 Filter1786911488190.406440125.6
2DLD Change Limit148819358.62317258.4
3Display Results35350.0162187.5
 (SQL Overall)178691359.04519755.8
 
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.