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

38 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
lithified164446(None) 
lithifies1545501lithifies
citified1438252cit_ified
lignified1445062lignified
liquified2244282liquified
nitrified1346722nitrified
vitrified1645982vitrified
citifies13310683cit_ifies
cityfied1742703cit_yfied
dignified1545573dignified
ignified1386213_ignified
kitschified245773kitschified
lignifies1346263lignifies
liquefied2242493liquefied
liquifies2144883liquifies
lithiases1244773lithiases
lithify1644763lithif__y
lithifying2073643lithifying
lithoed1137833lith__oed
lithoid1148773lith_oi_d
metrified1547853metrified
micrified17126793micrified
minified1439653mi_nified
nidified1346763ni_dified
nigrified1445323nigrified
nitrifier1245963nitrifier
nitrifies12107923nitrifies
notified1238363not_ified
petrified1548333petrified
ratified12310503rat_ified
signified1446043signified
sissified1345543sissified
vilified1547243vi_lified
vinified1537543vi_nified
vitrifies1547223vitrifies
vivified1845893vi_vified
zincified2444293zincified
zinkified2643163zinkified

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 Filter1786911486410.423422437.4
2DLD Change Limit148641387.76619140.0
3Display Results38380.0132923.1
 (SQL Overall)178691388.20221786.3
 
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.