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

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

51 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
miskicking184424(None) 
mimicking2043872mi_micking
misliking1637112misli_king
mosaicking1942962mosaicking
musicking1844512mus_icking
disliking1537313disli_king
finicking1954463fi_nicking
fossicking2042453fossicking
gimmicking2241983gimmicking
kicking133314023___kicking
mafficking2542643mafficking
magicking19113543m_agicking
misacting1439083mis_acting
misaiming1437873misai_ming
misbiasing1545203misbiasing
misbilling1545543misbilling
misbinding1645063misbinding
misciting1439673misci_ting
miscooking1945003miscooking
miscuing1338733mis__cuing
misdialing1446263misdialing
misfiling1537223misfi_ling
misfiring1536973misfi_ring
misfitting1645533misfitting
misgiving1645593misgi_ving
mishitting1645993mishitting
miskeeping1944353miskeeping
miskick1435613miskick___
miskicked1744063miskick_ed
miskicks1544763miskick__s
misknowing2042823misknowing
misliving1546983misli_ving
mismaking18118023mis_making
mismarking1955863mismarking
mispricing1746713mispric_ing
missioning1347403missioning
mistaking1699693mis_taking
misthinking2143423misthinking
mistiming1438913misti_ming
mistitling1346223mistitling
misyoking1944923mis_yoking
nitpicking1943033nitpicking
outkicking1644683outkicking
picnicking2142793picnicking
pigsticking2152433pigsticking
sicking143720173__s_icking
skinking12299773__skinking
slicking153712593__slicking
snicking153610233__snicking
sticking153513463__sticking
unsticking1744943unsticking

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603515.64324916.4
3Display Results51510.0301700.0
 (SQL Overall)178691516.07929394.8
 
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.