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 “annulated” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
annulated103860(None) 
angulated1139221angulated
annulate8310921annulate_
cannulated1346501cannulated
adulated1039752a_dulated
ambulated1457132ambulated
angulate9312012angulate_
angulates10310862angulates
annotated1095612annotated
annulled944842annul_led
cannulate1148632cannulate_
cannulates1247782cannulates
canulated12310672canulated
insulated10310712insulated
lunulated1036782lunulated
undulated11310082undulated
ablated102513443a__blated
abnegated1344163abnegated
acidulated14195153acidulated
actuated1138743actu_ated
aculeated1247723a_culeated
acylated1437873a_cylated
adulate8313233a_dulate_
adulates9311913a_dulates
alated75625153a___lated
alkylated1753483alkylated
ambulate1239733ambulate_
ambulates1348383ambulates
amputated1444463amputated
animated111612373a_nimated
annates72415423ann__ates
annealed936343ann_ealed
annihilated1552873annihilated
annotate877713annotate_
annotates977293annotates
annualized2044613annualized
annular737693annula__r
annularly1243613annularly
annulation1068953annulation
annulet7311593annul__et
annulets845813annulet_s
annulose844473annulose_
annuluses943913annuluses
annunciated14122603annunciated
ansated84214003a_n_sated
antedated1146703antedated
arcuated1138803arcu_ated
areolated1089713areolated
aurated83817793a__urated
calculated1577803calculated
cannulae1046493cannula_e_
canulate10314553canulate_
canulates11312873canulates
capsulated1545653capsulated
conflated1539333conflated
copulated142710483copulated
crenulated1356043crenulated
cumulated14237843cumulated
denudated1244933denudated
emulated11310793_emulated
fabulated1546323fabulated
granulated1256943granulated
incubated1446983incubated
inculcated1546173inculcated
inculpated1545733inculpated
indurated1139013indurated
inflated12410863_inflated
innovated1344573innovated
inoculated1347593inoculated
insolated1039713insolated
insulate8312843insulate_
insulates9311843insulates
insulted937193insul_ted
intubated1246453intubated
inundated1144753inundated
jaculated19289053jaculated
jugulated1844023jugulated
ligulated11247363ligulated
lobulated12106423lobulated
loculated1288313loculated
lunulate838253lunulate_
maculated142411503maculated
manducated1644563manducated
manipulated1643963manipulated
modulated1336713modulated
nutated83113423__nutated
osculated1298143osculated
ovulated1237083_ovulated
peculated142310853peculated
pinnulate1145763pinnulate_
populated14228803populated
regulated11310463regulated
sacculated1546623sacculated
simulated1238283simulated
sinuated938413sinu_ated
tabulated1237303tabulated
tegulated1146633tegulated
tubulated1256063tubulated
ululated947663_ululated
undulate9310403undulate_
undulates1048923undulates
ungulate939803ungulate_
ungulates1048353ungulates
uninflated1474763uninflated
uninsulated1244303uninsulated
unrelated10310433unrelated

Search took 7 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.420425454.8
2DLD Change Limit1486411066.09624383.4
3Display Results1061060.0462304.3
 (SQL Overall)1786911066.56227231.2
 
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.