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

55 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
mispainted154501(None) 
mispointed1545571mispointed
misprinted1545981misprinted
impainted1454772_impainted
mispaint121111892mispaint__
mispaints13106182mispaint_s
misparted1437262mispa_rted
misplanted1565442misplanted
bepainted1484343_bepainted
depainted1375843_depainted
discanted1339333disca_nted
disdained1246023disdain_ed
disjointed1944833disjointed
disparted1338853dispa_rted
displanted14126633displanted
distained1139603distain_ed
imprinted1445753_imprinted
misacted1338673mis_a_cted
misaimed1338093mis_ai_med
miscited13310423mis_ci_ted
miscoined1448443miscoin_ed
miscounted1546063miscounted
misdated121211123misda__ted
misedited1346783misedi_ted
misfitted1544963mis_fitted
mishanter1446453misha_nter
misinter1038833mis__inter
misjoined1945453misjoin_ed
mismated131111333misma__ted
misoriented1453943misoriented
mispaged1438243mispa__ged
mispainting1645293mispainting
misparsed1446253mispa_rsed
mispatched2053833mispatched
mispenned1445413misp_enned
misplanned1583873misplanned
mispoint121012363mispoint__
mispoints13106633mispoint_s
mispoised1446803mispoi_sed
mispriced1646423mispri_ced
misprint12912973misprint__
misprints13107223misprint_s
misprized2346603mispri_zed
misraised1268313misrai_sed
misrated111315383misra__ted
missuited1257023missui_ted
mistrained1347583mistrain_ed
outpainted1344323outpainted
painted104214633___painted
pinpointed1542543pinpointed
repainted1277863_repainted
sainted84114243__s_ainted
splinted11369253__splinted
sprinted113411163__sprinted
unpainted1237183_unpainted

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 Limit140603556.22022605.0
3Display Results55550.0301833.3
 (SQL Overall)178691556.65626846.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.