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

157 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
subulate1031274(None) 
sublate9315361sub_late
tubulate1038271tubulate
ambulate1239732ambulate
cumulate123110222cumulate
cupulate122810032cupulate
fabulate1339202fabulate
jubilate1746552jubilate
jugulate1645482jugulate
lobulate1078832lobulate
lunulate838252lunulate
sibilate1049532sibilate
simulate10311132simulate
subjugate1943552subjugate
sublated11311502sub_lated
sublates10315002sub_lates
subovate1347332subovate
substate101711092substate
sufflate1456182sufflate
tabulate10310892tabulate
tubulated1256062tubulated
tubulates1147232tubulates
ululate749962_ululate
ustulate868322ustulate
ablate82219213_ab_late
adulate8313233_adulate
ambulated1457133ambulated
ambulates1348383ambulates
angulate9312013angulate
annulate8310923annulate
blate75933783__b_late
bullate93415073bu_llate
butylate1345213butylate
canulate10314553canulate
copulate122614113copulate
cucullate1344733cucullate
cumulated14237843cumulated
cumulates13258973cumulates
cupulae11347853cupula_e
emulate9314123_emulate
fabulated1546323fabulated
fabulates1447733fabulates
fibulae12237013fibula_e
hamulate1359013hamulate
insulate8312843insulate
jaculate172311783jaculate
jubilated1944933jubilated
jubilates1845843jubilates
jugulated1844023jugulated
jugulates1744603jugulates
ligulate92510253ligulate
lobulated12106423lobulated
loculate101011403loculate
lunulae735613lunula_e
lunulated1036783lunulated
maculate122815623maculate
modulate1138593modulate
mutilate10312273mutilate
nebulae955493nebula_e
oblate82214743_ob_late
osculate101010613osculate
ovulate1039453_ovulate
peculate122414673peculate
populate122812093populate
pullulate1144703pullulate
pustulate1177243pustulate
regulate9313023regulate
rosulate8310903rosulate
sabulose1044613sabulose
sacculate1349023sacculate
saturate8312813saturate
scopulate1366543scopulate
scutate9310323s_cutate
serrulate946983serrulate
sibilated1246713sibilated
sibilates1148443sibilates
simulated1238283simulated
simulates1139853simulates
sinuate7412163sinu_ate
situate7410783situ_ate
slate55438283s___late
solate64526073s__olate
soulmate1047193s_oulmate
spatulate11107173spatulate
speculate13239193speculate
spiculate132210163spiculate
sporulate1146953sporulate
stellate8310503stellate
stimulate1148233stimulate
stipulate1147323stipulate
stylate10179773s_tylate
subacute1245753subacute
subalar9118073subala_r
subbase1139323sub_base
subcaste1287853subcaste
subclaim1444663subclaim
subclan1147173subcla_n
subclans1247413subclans
subclass1246623subclass
subclause1353843subclause
subcult1149603subcul_t_
subcults1246933subcul_ts
subframe1546333subframe
subgrade1246053subgrade
subjugated2142673subjugated
subjugates2043153subjugates
sublease1038383sublease
sublet82827243sub_let_
sublets92616703sub_lets
sublimate1347443sublimate
sublime11310363sub_lime
subline9316893sub_line
sublot82315523sub_lot_
sublots92410913sub_lots
subphase1555603subphase
subplot1158133subplot_
subplots1255773subplots
subrace11313003sub_race
subrogate1246043subrogate
subrule939643subrul__e
subsale9310543sub_sale
subscale1247603subscale
subsite9412873sub_site
subspace1445683subspace
substage11117183substage
substates111410333substates
substrate11178793substrate
subtle82113433subtl__e
subtlety1345063subtlety
subunit948953subunit_
subunits1046623subunits
sufflated1644623sufflated
sufflates1546033sufflates
sulcate9314423su_lcate
sulfate10311653su_lfate
sulfurate1246443sulfurate
sullage859913su_llage
sulphate1346643sulphate
summate113611663su_mmate
supinate10310313supinate
suppurate1345433suppurate
suricate10312613suricate
susurrate943863susurrate
tabulated1237303tabulated
tabulates1139143tabulates
tribulate1148083tribulate
tubate82813173tub__ate
tubular9267473tubula_r
tubulator1145033tubulator
tubule839853tubul__e
tubulose1043903tubulose
tubulure1042773tubulure
ululated947663_ululated
ululates848433_ululates
undulate9310403undulate
ungulate939803ungulate
uvulae945323_uvula_e

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621577.59319249.6
3Display Results1571570.0801962.5
 (SQL Overall)1786911578.07922118.0
 
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.