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

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
remodifies1611602(None) 
premodifies19114221premodifies
recodifies16106321recodifies
remodified17115261remodified
modifies1439162__modifies
premodified20113582premodified
recodified1765542recodified
reedifies1347322re_edifies
renotifies1356892renotifies
ammonifies17104083ammonifies
codifies1439643__codifies
commodifies2153143commodifies
detoxifies2143603detoxifies
edifies113012283_e__difies
humidifies1943553humidifies
modified1537273__modified
modifier1446703__modifier
modifiers1584483__modifiers
prenotifies1644883prenotifies
ramifies13310503ram__ifies
ramosities1246873ramosities
rebodies1139163rebod__ies
rectifies14310813re_ctifies
redefies12710163re__defies
reedified1446503re_edified
refortifies1753773refortifies
reglorifies1553003reglorifies
reifies104218283re___ifies
remediates1346933remediates
remedies11310553remed__ies
remobilizes2444573remobilizes
remodify1743953remodif__y
remodifying2143853remodifying
renotified1455813renotified
repacifies1745653repacifies
repurifies1546143repurifies
resinifies1346913resinifies
resolidifies1651943resolidifies
reunifies1247583re_unifies
reverifies1645973reverifies
revivifies1944553revivifies
rigidifies1543593rigidifies
rimosities1246643rimosities
semideifies17143563semideifies
unmodified1742903unmodified

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 Filter1786911406030.453394461.4
2DLD Change Limit140603457.32619192.3
3Display Results45450.0331363.6
 (SQL Overall)178691457.81222873.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.