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

146 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
tabulate1031089(None) 
fabulate1339201fabulate
tabulated1237301tabulated
tabulates1139141tabulates
tubulate1038271tubulate
ablate82219212_ab_late
adulate8313232_adulate
ambulate1239732ambulate
canulate10314552canulate
fabulated1546322fabulated
fabulates1447732fabulates
hamulate1359012hamulate
jaculate172311782jaculate
lobulate1078832lobulate
maculate122815622maculate
subulate10312742subulate
tabulable1344042tabulable
tabular9279762tabula_r
tabulator1145922tabulator
tribulate1148082tribulate
tubulated1256062tubulated
tubulates1147232tubulates
abate76627843_ab__ate
ablated102513443_ab_lated
ablates92416903_ab_lates
ablaze17239833_ab_laze
acuate8315633_acu_ate
aculeate1039913_aculeate
acylate12310533_acylate
adulated1039753_adulated
adulates9311913_adulates
alate55340323_a__late
alulae6312743_alula_e
ambulated1457133ambulated
ambulates1348383ambulates
angulate9312013angulate
annulate8310923annulate
aurate64426473_a_urate
blate75933783__b_late
bullate93415073__bullate
calculate1389873calculate
cannulate1148633cannulate
canulae9311183canula_e
canulated12310673canulated
canulates11312873canulates
capsulate1347563capsulate
caudate10311353ca_udate
coagulate1258083coagulate
copulate122614113copulate
cumulate123110223cumulate
cupulate122810033cupulate
ejaculate18187163ejaculate
emulate9314123_emulate
fabular12288693fabula_r
fabulator1445393fabulator
faculae123210353facula_e
fibulae12237013fibula_e
gallate83417123ga_llate
granulate1059183granulate
gratulate1047683gratulate
haulage1136913ha_ulage
insulate8312843insulate
jaculated19289053jaculated
jaculates182810363jaculates
jubilate1746553jubilate
jugulate1645483jugulate
labellate11126923labellate
labiate91313573lab_iate
lacunate10128963lacunate
lazulite1745033lazulite
ligulate92510253ligulate
lobulated12106423lobulated
loculate101011403loculate
lunulate838253lunulate
maculae113412863macula_e
maculated142411503maculated
maculates132013723maculates
malate84624553ma__late
maturate10312613maturate
modulate1138593modulate
nebulae955493nebula_e
oblate82214743_ob_late
osculate101010613osculate
ovulate1039453_ovulate
pabular11259473pabula_r
palate84226783pa__late
papulae11249353papula_e
peculate122414663peculate
planulate1146903planulate
populate122812093populate
radulae837963radula_e
regulate9313023regulate
rosulate8310903rosulate
sabulose1044613sabulose
sacculate1349023sacculate
saturate8312813saturate
sibilate1049533sibilate
simulate10311133simulate
spatulate11107173spatulate
stimulate1148233stimulate
stipulate1147323stipulate
sublate9315363sub_late
tabla73318363tab_la__
tablas83716163tab_la_s
tablature1143053tab_lature
table75429603tab_l__e
tablemate1344833tablemate
tablet84227643tab_let_
tableted1137533tab_leted
tablets94714373tab_lets
tabularly1443513tabularly
tabulating1346413tabulating
tabulation1247813tabulation
tabulators1245293tabulators
tabuli839363tabul__i
tabulis938833tabul_is
tailgate946823tailgate
tallage82712073ta_llage
tannate71813523ta_nnate
tantalate9107373tantalate
tartrate899683tartrate
tegulated1146633tegulated
template1238433template
tinplate1047743tinplate
toeplate1047613toeplate
toluate7159343tolu_ate
torulae758553torula_e
trabeate1049483trab_eate
trabeculate1552903trabeculate
translate9412273translate
tribulated1345823tribulated
tribulates1247193tribulates
tribunate1144953tribunate
tubate82813173t__ubate
tubular9267473tubula_r
tubulator1145033tubulator
tubule839853tubul__e
tubulose1043893tubulose
tubulure1042773tubulure
ululate749963_ululate
undulate9310403undulate
ungulate939803ungulate
ustulate868323ustulate
vacuolate1445223vacuolate
vallate103016563va_llate
valuate102512733valu_ate

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621469.39315560.7
3Display Results1461460.1231187.0
 (SQL Overall)1786911469.67218475.1
 
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.