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

32 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
instantiated135319(None) 
instantiate1154011instantiate_
instantiates1253611instantiates
ingratiated1354023ingra_tiated
insatiate948063ins_a_tiate_
instantiating1462933instantiating
instantiation13134053instantiation
substantiated1672983substantiated
enstatite946194ensta_ti_te_
enstatites1044524ensta_ti_tes
inactivated1744554in__activated
infatuated1443924in_fa_tuated
ingratiate1144884ingra_tiate_
ingratiates1254414ingra_tiates
initiated10510114in___itiated
insatiately1453514ins_a_tiately
insinuated1144814ins_in_uated
instanced1245694instan___ced
instancies1246614instanci__es
instanter946244instan___ter
instantiations1493514instantiations
instated91613334ins___t_ated
instigated1247684inst__igated
instituted1144934inst_it_uted
intenerated1247014in_tenerated
intonated1048304in_ton__ated
potentiated1494364_potentiated
sanitated1068994__s_anitated
satiated9311604__s_a_tiated
substantiate1473784substantiate_
substantiates1573374substantiates
unsubstantiated1871834unsubstantiated

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790328.53014629.5
3Display Results32320.033969.7
 (SQL Overall)178691328.71920494.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.