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

139 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
fabulate133920(None) 
fabulated1546321fabulated
fabulates1447731fabulates
tabulate10310891tabulate
ablate82219212_ab_late
adulate8313232_adulate
ambulate1239732ambulate
canulate10314552canulate
fabular12288692fabula_r
fabulator1445392fabulator
faculae123210352facula_e
fibulae12237012fibula_e
hamulate1359012hamulate
jaculate172311782jaculate
lobulate1078832lobulate
maculate122815622maculate
subulate10312742subulate
tabulated1237302tabulated
tabulates1139142tabulates
tubulate1038272tubulate
abate76627843_ab__ate
ablated102513443_ab_lated
ablates92416903_ab_lates
ablaze17239833_ab_laze
acuate8315633_acu_ate
aculeate1039923_aculeate
acylate12310533_acylate
adulated1039753_adulated
adulates9311913_adulates
alate55340333_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
confabulate1853663confabulate
copulate122614113copulate
cumulate123110223cumulate
cupulate122810033cupulate
ejaculate18187163ejaculate
emulate9314123_emulate
fable105824753fab_l__e
fabricate1646833fabricate
fabulating1645523fabulating
fabulators1544693fabulators
fabulist1347673fabulist
fabulists1444723fabulists
fabulous1344853fabulous
faceplate1645223faceplate
facula112912233facula__
facular122810443facula_r
faculty1535573facul_ty
falcate12311623fa_lcate
fasciate1347563fasciate
fault85428313fa_ul_t_
faulted11227723fa_ul_ted
faults94513553fa_ul_ts
faulty12429363fa_ul_ty
faunae95210373fa_una_e
faveolate15104623faveolate
fayalite1447053fayalite
feculae12339203fecula_e
fellate10313433f_ellate
ferulae10309603ferula_e
fibula11258053fibula__
fibular12267973fibula_r
fibulas12228563fibula_s
figurate1237193figurate
fistulate1246453fistulate
flabellate15104313flabellate
folate93320393f__olate
formulate1446993formulate
gallate83417133ga_llate
granulate1059183granulate
gratulate1047683gratulate
haulage1136913ha_ulage
insulate8312843insulate
jaculated19289053jaculated
jaculates182810363jaculates
jubilate1746553jubilate
jugulate1645483jugulate
labellate11126933labellate
labiate91313573lab_iate
lacunate10128963lacunate
lazulite1745033lazulite
ligulate92510253ligulate
lobulated12106423lobulated
loculate101011403loculate
lunulate838253lunulate
maculae113412863macula_e
maculated142411503maculated
maculates132013723maculates
malate84624563ma__late
maturate10312623maturate
modulate1138593modulate
nebulae955493nebula_e
oblate82214743_ob_late
osculate101010613osculate
ovulate1039453_ovulate
pabular11259473pabula_r
palate84226793pa__late
papulae11249353papula_e
peculate122414673peculate
planulate1146903planulate
populate122812093populate
radulae837963radula_e
regulate9313023regulate
rosulate8310903rosulate
sabulose1044613sabulose
sacculate1349023sacculate
saturate8312813saturate
sibilate1049533sibilate
simulate10311133simulate
spatulate11107173spatulate
sublate9315363sub_late
tabulable1344043tabulable
tabular9279763tabula_r
tabulator1145923tabulator
tribulate1148083tribulate
tubulated1256063tubulated
tubulates1147233tubulates
ululate749963_ululate
undulate9310403undulate
ungulate939803ungulate
ustulate868323ustulate
vacuolate1445223vacuolate
vallate103016563va_llate
valuate102512733valu_ate

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.436409841.7
2DLD Change Limit1461621397.64019131.2
3Display Results1391390.0632206.3
 (SQL Overall)1786911398.13921954.9
 
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.