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

74 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
miscataloging196104(None) 
cataloging1444953___cataloging
miscatalog1551453miscatalo___g
miscataloged1861133miscatalog_ed
miscatalogs1651303miscatalog__s
recataloging1651723_recataloging
cataloguing1552304___cataloguing
misatoning1346444mis_at__oning
miscalling1547864misc__al_ling
miscaptioning2061404miscaptioning
mischarging2043714misc_ha_rging
miscoloring1644264misc__oloring
mismanaging1743024mismana__ging
catalogic1446685___catalogi_c
catalyzing2544775___catalyzing
dialoging1246315di____aloging
disallowing1643285dis_a_llowing
discharging1943945disc_ha_rging
disclosing1446615disc___losing
discoloring1544745disc__oloring
disparaging1644725dispara__ging
escalloping1652155_esca_lloping
escaloping1543725_esc__aloping
mascaraing1544255mascara___ing
misacting1439085misact____ing
misadapting1743065mis_ada_pting
misaligning1543645mis___aligning
misallotting1552115mis_a_llotting
misallying1644315mis___allying
misapplying2152465mis_appl_ying
misawarding1842995mis_awa_rding
misbalancing1951685misbala_ncing
misbuttoning17101325misbut_toning
miscalculating2161955miscalculating
miscarrying1942725misc__arrying
miscasting1557075misc__a_sting
mischoosing1952925misc__hoosing
misciting1439675miscit____ing
misclaiming1844095misc_la_iming
misclassing1644125misc_la_ssing
miscoding1538185misc____oding
miscooking1945005misc___ooking
miscreating1648495miscrea__ting
miscutting1576055miscut___ting
misdating131010665misdat____ing
misdealing1457365mis_deal__ing
misdeveloping2261375misdeveloping
misdialing1446265mis_dial__ing
misdialling1543305mis_dial_ling
miseating121215435miseat____ing
misemploying2252075mis_employing
misgauging1543905mis__ga_uging
mishandling1843335mishandl__ing
mislabeling1642795mislabel__ing
mislabelling1751825mislabel_ling
mislaboring1643035mis__laboring
mislodging1543975mis____lodging
mismatching21123405mismat__ching
mismating141211825mismat____ing
mispackaging2451345mispa_ckaging
mispaging1537805mis__pa__ging
mispatching21133435mispat__ching
misrating121014855misrat____ing
misstamping1842995mis_sta_mping
misstarting14125205mis_sta_rting
misstating13129315mis_sta__ting
misstyling1643835mis_styl__ing
mistaking1699695mis__ta__king
misthrowing2043185mis__throwing
mistitling1346225mistit_l__ing
mistutoring1442825mis__tutoring
misvaluing1684605mis__val_uing
scalloping1543955__sca_lloping
scatologies1446865__scatologies

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.423422437.4
2DLD Change Limit124790748.56314573.2
3Display Results74740.0461608.7
 (SQL Overall)178691749.03219784.2
 
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.