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

51 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
gratifying187421(None) 
ratifying1656821_ratifying
beatifying1945732beatifying
brutifying1943412brutifying
gasifying1744522g_asifying
gratifyingly2381012gratifyingly
ramifying1855602_ramifying
rarifying1646312_rarifying
stratifying1843522stratifying
acetifying1944453acetifying
basifying1845073_basifying
beautifying2043413beautifying
carnifying1945043carnifying
certifying1945313certifying
citifying1845383_citifying
clarifying1944853clarifying
coalifying1945033coalifying
crucifying2143513crucifying
fortifying2045153fortifying
fructifying2352373fructifying
gentrifying1943813gentrifying
glorifying1843673glorifying
graffiting1842923graffiting
grafting13319623gra__fting
graining102813183gra_i_ning
gratified1446253gratif_ied
gratifier1345823gratif_ier
gratifies1347993gratif_ies
gratify1436113gratify___
gratineeing1351673gratineeing
grating93923183grat___ing
graying124115883gra___ying
grifting13299263gr__ifting
justifying2444053justifying
mortifying1944923mortifying
mystifying2243943mystifying
nazifying2543473_nazifying
notifying1645623_notifying
opacifying2143363opacifying
pacifying2045503_pacifying
prettifying2044003prettifying
qualifying2643973qualifying
quantifying2743213quantifying
rarefying1654693_rarefying
rationing1039783_rationing
rectifying1946373rectifying
reifying1539383_r_eifying
salifying1636333_salifying
satisfying1743383_satisfying
scarifying1945013scarifying
testifying1745403testifying

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 Filter1786911406030.436409841.7
2DLD Change Limit140603518.58016387.3
3Display Results51510.0301700.0
 (SQL Overall)178691519.04619753.6
 
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.