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

(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
ostentation114696(None) 
ostentations1246121ostentations
assentation1146182assentation
orientation1147572orientation
ostentatious1252862ostentatious
sustentation1255022sustentation
assentations1245833assentations
attenuation1144183attenuation
attestation1145183attestation
catenation1249523caten_ation
cementation1559703cementation
contestation1448663contestation
dentation10315243__dentation
detestation1248363detestation
extenuation1845183extenuation
fomentation1647713fomentation
indentation1248373indentation
lamentation13106573lamentation
mentation11313983__mentation
orientations1246913orientations
outstation1046163out_station
potentiation1455973potentiation
sensation9510583_s_ensation
sternutation1253963_sternutation
sustentations1354783sustentations
abstention1254394absten__tion
accentuation1653464accentuation
acceptation1765324acceptation
affectation1943844affectation
alienation1048794alien_ation
alimentation14105334alimentation
alteration10612904alte_ration
altercation1347014altercation
alternation1147624alternation
attention946104atten__tion
attenuations1243804attenuations
attestations1244464attestations
augmentation1554394augmentation
catenations1348364caten_ations
cementations1659014cementations
commendation1946514commendation
compensation18126504compensation
concentration1758014concentration
condensation1546784condensation
constellation1554804constellation
consternation15106364consternation
contention12412224conten__tion
contestations1547734contestations
continuation1448194continuation
crenation11412924_cren_ation
decantation1448944decantation
delectation1448554delectation
denotation11311084__denotation
dentations11413634__dentations
dentition1049634__dentition
destination12413844destin_ation
detention10169544deten__tion
detestations1347584detestations
detonation11310944deton_ation
dispensation1555604dispensation
dissertation1366094dissertation
distention11158874disten__tion
documentation18144724documentation
emendation1346554_emendation
enation73419234___en_ation
estimation12410844est_imation
estivation1349814est_ivation
expectation2266484expectation
extenuations1945084extenuations
fermentation1756824fermentation
fetation11613144__fe_tation
fomentations1746794fomentations
forestation1447004forestation
gestation10310664__gestation
guttation1046174gut__tation
hebetation1557094hebe_tation
incantation1347054incantation
indentations1347884indentations
infestation1447044infestation
instantiation13134064instantiation
integration121310494integration
inteneration1248624inteneration
intention9412014inten__tion
interstation12410414interstation
intonation10410264inton_ation
iteration9515034_ite_ration
lamentations1495984lamentations
literation10511414lite_ration
mentations12312584__mentations
molestation1365964molestation
observation1665064observation
obturation1297144obt_uration
occultation1545134occultation
operation11314004o_pe_ration
ordination1149414ordin_ation
orientating1245774orientating
orientational1353804orientational
ornamentation1573614ornamentation
oscillation1345504oscillation
osculation1249674os_culation
ostentatiously1781834ostentatiously
ostinati846884ostin_ati__
ostinato846494ostin_at_o_
ostinatos946174ostin_at_os
outstations1145344out_stations
oxygenation2252874oxygen_ation
ozonation1845674o_zon_ation
patination12312574patin_ation
peltation11312964__peltation
perennation1348084perennation
pigmentation1754484pigmentation
placentation1694154placentation
plantation1248534_plantation
postelection1654554postelection
postulation13119134post_ulation
potentiations1555184potentiations
presentation1448994presentation
protestation1456364protestation
recantation1349864recantation
reorientation1375594reorientation
restation9316914__restation
retention91611484reten__tion
saltation9312004_s_altation
salutation1048904_salutation
sanitation10412044_sanitation
sedation9312454_s_e_dation
segmentation1556004segmentation
sensations1059854_s_ensations
seriation9318064_s_eriation
serration9414064_s_erration
siltation939214_s_iltation
sinuation9310414_s_inuation
speciation1449394_speciation
stagnation1145544_stagnation
starvation1345494_starvation
station72717244_s___tation
stentorian1055224_stentorian
sternutations1353754_sternutations
striation9313484_st_riation
substation1248994_substation
sustentative15133104sustentative
temptation1446384__temptation
tentative1247814__tentative
unostentatious1461124unostentatious
vegetation1448214vege_tation
venation11513504__ven_ation

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191469.12616307.1
3Display Results1461460.0931569.9
 (SQL Overall)1786911469.64218532.6
 
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.