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

47 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
acetifier144486(None) 
acetified1545891acetified
acetifiers1543401acetifiers
acetifies1447131acetifies
acidifier15124382acidifier
certifier1447352_certifier
rectifier1457732rectifier
acetify1545003acetif__y
acetifying1944453acetifying
acidified16104983acidified
acidifiers16113223acidifiers
acidifies15126453acidifies
actioner1048663ac_tioner
aerified121310133a_erified
aerifies111313393a_erifies
amplifier16104703amplifier
artificer1444023a_rtificer
certified1548413_certified
certifiers1545143_certifiers
certifies14310323_certifies
citified1438253_citified
citifies13310683_citifies
codifier1447163_codifier
deifier113013123_de_ifier
edifier11309263__edifier
fortifier1546253fortifier
gratifier1345823gratifier
identifier1444263identifier
justifier1944363justifier
mortifier1446923mortifier
mystifier1744363mystifier
notifier1137423_notifier
pacifier1557503pac__ifier
petrifier1447123_petrifier
prettifier1543973prettifier
ratifier1139673_ratifier
rectified1539243rectified
rectifiers1545173rectifiers
rectifies14310813rectifies
reifier103414523_re_ifier
sanctifier1553493sanctifier
scarifier1446653scarifier
scorifier1445413scorifier
specifier1645683specifier
tackifier1844143tac_kifier
testifier12116893testifier
verifier14159203_verifier

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 Filter1786911486410.423422437.4
2DLD Change Limit148641477.45319943.8
3Display Results47470.0162937.5
 (SQL Overall)178691477.89222642.0
 
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.