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

108 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
tabulates113914(None) 
fabulates1447731fabulates
tabulate10310891tabulate_
tabulated1237301tabulated
tubulates1147231tubulates
ablates92416902_ab_lates
adulates9311912_adulates
ambulates1348382ambulates
canulates11312872canulates
fabulate1339202fabulate_
fabulated1546322fabulated
jaculates182810362jaculates
maculates132013722maculates
tabulator1145922tabulator
tabulators1245292tabulators
tribulates1247202tribulates
tubulate1038272tubulate_
tubulated1256062tubulated
abates85825033_ab__ates
ablate82219213_ab_late_
ablated102513443_ab_lated
acylates1339743_acylates
adulate8313233_adulate_
adulated1039753_adulated
alates64833973_a__lates
ambulate1239733ambulate_
ambulated1457133ambulated
angulates10310863angulates
calculates1498703calculates
cannulates1247783cannulates
canulate10314553canulate_
canulated12310673canulated
caudates11310263ca_udates
coagulates13137453coagulates
copulates132612463copulates
cumulates13258973cumulates
ejaculates19166443ejaculates
emulates10312573_emulates
fabulator1445393fabulator
fabulators1544693fabulators
gallates92815533ga_llates
granulates1148463granulates
gratulates1157133gratulates
hamulate1359013hamulate_
haulages1236623ha_ulages
insulates9311843insulates
jaculate172311783jaculate_
jaculated19289053jaculated
jubilates1845843jubilates
jugulates1744603jugulates
labiates101011513lab_iates
lazulites1844253lazulites
lobulate1078833lobulate_
lobulated12106423lobulated
maculate122815623maculate_
maculated142411503maculated
malates93522613ma__lates
maturates11311763maturates
modulates1238053modulates
oblates91913243_ob_lates
osculates11109393osculates
ovulates1148523_ovulates
palates93624943pa__lates
peculates132112543peculates
populates132710673populates
regulates101211723regulates
saturates9811603saturates
sibilates1148443sibilates
simulates1139853simulates
stimulates1247383stimulates
stipulates1256683stipulates
sublates10315003sub_lates
subulate10312753subulate_
tablas83716163tab_la__s
tablatures1242783tab_latures
tablemates1444693tablemates
tables84524893tab_l__es
tableted1137533tab_leted
tablets94714383tab_let_s
tabulable1344043tabulable
tabular9279773tabula__r
tabularly1443513tabularly
tabulating1346433tabulating
tabulation1247813tabulation
tabulations1346853tabulations
tabulis938833tabul__is
tailgates1046533tailgates
tallages92312003ta_llages
tannates81911953ta_nnates
tantalates10106703tantalates
tartrates979573tartrates
tegulated1146633tegulated
templates1348273templates
tinplates1147773tinplates
toeplates1147183toeplates
toluates8138903tolu_ates
translates10411703translates
tribulate1148083tribulate_
tribulated1345823tribulated
tribunates1244173tribunates
tubulator1145033tubulator
tubulators1244513tubulators
tubules9310233tubul__es
tubulures1142623tubulures
ululates848433_ululates
undulates1048923undulates
ungulates1048353ungulates
valuates112811203valu_ates

Search took 8 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.403443402.0
2DLD Change Limit1486411086.83021763.0
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.27924548.8
 
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.