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 “ultracritical” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

37 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
ultracritical176324(None) 
ultrapractical20121613ultrapractical
ultraradical1563213ultra_radical
acritical1348144____acritical
diacritical1673394__diacritical
nutraceutical1771584nutraceutical
overcritical1962634over_critical
precritical1764404__precritical
supercritical1973484super_critical
ultraphysical2371834ultraphysical
ultraradicals1662394ultra_radicals
ultrarational1363514ultra_rational
uncritical1454984u___ncritical
unpractical1753764unprac__tical
autocratical1674085aut_ocratical
critical12310265_____critical
extracranial2162815extracrani_al
hypercritical2563515hypercritical
hypocritical2463125_hypocritical
impractical1953085imprac__tical
intracranial1463665intracrani_al
meteoritical1652955met_eoritical
noncritical1556115__noncritical
nutraceuticals187915nutraceuticals
parasitical1555655_para_sitical
practical1548845__prac__tical
subcritical1753435__subcritical
tactical1248845__t_ac__tical
ultracasual1362695ultrac__asual
ultracautious1562285ultracautious
ultrachic1645085ultrac__hic__
ultraistic1246375ultra_istic__
ultraliberal1462235ultra_liberal
ultrarich1455395ultra_r__ic_h
ungrammatical2062425ungrammatical
untheoretical1861985untheoretical
untraditional1463875untra_ditional

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 Filter1786911247900.403443402.0
2DLD Change Limit124790379.14313648.7
3Display Results37370.0301233.3
 (SQL Overall)178691379.57618660.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.