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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
miscaptioning206140(None) 
captioning1545703___captioning
misatoning1346443mis_a_t_oning
miscaption1644763miscaptio__n_
miscaptioned19151943miscaption_ed
miscaptions1744183miscaptio__ns
cautioning1345724___cautioning
disciplining1853384discipli_ning
misaligning1543644mis_a_ligning
misassigning1652184mis_assigning
misbuttoning17101324mis_buttoning
miscasting1557074miscast___ing
miscataloging1961044miscataloging
miscoining1597764misc__oi_ning
misfunctioning2261234misfunctioning
mispositioning1961374mispositioning
missioning1347404mis___sioning
recautioning1553764_recautioning
restationing1354264resta_tioning
stationing1145284__sta_tioning
vacationing1753044_vaca_tioning
auctioning1344895_auc__tioning
cantoning12310885___cant_oning
caprioling1544525___caprioling
captaining1546075___captaining
cartoning12311115___cart_oning
cartooning1345885___cartooning
cocaptaining19101915_cocaptaining
disappointing1952865dis_appointing
disapproving2152375dis_approving
discanting1449455discant___ing
discepting1658475discept___ing
discontinuing1783245discontinuing
disdaining1345995disda__i_ning
distaining1248905dista__i_ning
fissioning1445125fis___sioning
fractioning1744335__fractioning
functioning1753245func__tioning
impassioning1752785_impassioning
marathoning1752825m_ara_thoning
megaphoning2052565m_egap_honing
mentioning1345795m___entioning
misacting1439085mis_act___ing
misadapting1743065misadapt___ing
misadvising1852925mis_advi_sing
misaiming1437875mis_a__i_ming
misaltering1445125mis_alt_ering
misapplying2152465mis_ap_plying
misbeginning1851685mis_beginning
miscalling1547865misca___lling
miscarrying1942725misca__rrying
mischoosing1952925misc__hoosing
misciting1439675misc___i_ting
misclaiming1844095misc_lai_ming
misclassifying2581225misclassifying
miscoding1538185misc____oding
miscoloring1644265misc__oloring
miscooking1945005misc___ooking
miscopying2044975miscop___ying
miscutting1576055misc_ut__ting
misdating131010665misda_t___ing
misdefining1843315mis_defi_ning
miseating121215435misea_t___ing
misemploying2252075misemp_loying
misjoining2085295mis__joi_ning
mislaboring1643035misla__boring
mismatching21123405misma_t_ching
mismating141211825misma_t___ing
mispainting1645295mis__painting
misparting1538085mispart___ing
mispatching21133435mispa_t_ching
mispenning1545775mis__p_enning
misplanning1653875mis__planning
mispointing1645795mis__pointing
mispoising1546585mis__poi_sing
mispricing1746715mis__pri_cing
misprinting1646825mis__printing
misprizing2447535mis__pri_zing
misraising1348125misra__i_sing
misrating121014855misra_t___ing
misreckoning2151915mis_reckoning
mistiming1438915mis___ti_ming
mistitling1346225mis___titling
mistraining1446505mis_trai_ning
mistuning1237675mis___t_uning
mistutoring1442825mis_tut_oring
motioning1247545m____otioning
munitioning1453035m__unitioning
occasioning1652515_occa_sioning
optioning1246555____optioning
picarooning1652435pi_ca_rooning
positioning1454555pos__itioning
rationing1039785___ra_tioning
sanctioning1453995__sanctioning
sectioning1346295__s_ectioning
suctioning1345345__s_uctioning
visioning1347065vis____ioning

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790979.42313243.1
3Display Results97970.0931043.0
 (SQL Overall)178691979.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.