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

54 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
mispainting164529(None) 
mispointing1645791mispointing
misprinting1646821misprinting
impainting1544502_impainting
misparting1538082mispa_rting
misplanting1645632misplanting
bepainting15144883_bepainting
depainting14156153_depainting
discanting1449453disca_nting
disdaining1345993disdain_ing
disjointing2045293disjointing
disparting1438933dispa_rting
displanting1546043displanting
distaining1248903distain_ing
imprinting1546023_imprinting
misacting1439083mis_a_cting
misaiming1437873mis_ai_ming
misbinding1645063mis_binding
miscasting1557073misca_sting
misciting1439673mis_ci_ting
miscoining1597763miscoin_ing
miscounting1646053miscounting
misdating131010663misda__ting
miseating121215433misea__ting
misediting1446573misedi_ting
misfitting1645533mis_fitting
mishitting1645993mis_hitting
misjoining2085293misjoin_ing
mismating141211823misma__ting
misorienting15154963misorienting
mispaging1537803mispa__ging
mispaint121111893mispaint___
mispainted1545013mispaint_ed
mispaints13106183mispaint__s
misparsing1546613mispa_rsing
mispatching21133433mispatching
mispenning1545773misp_enning
misplanning1653873misplanning
mispoising1546583mispoi_sing
mispricing1746713mispri_cing
misprizing2447533mispri_zing
misraising1348123misrai_sing
misrating121014853misra__ting
missuiting1356743missui_ting
misthinking2143423misthinking
mistraining1446503mistrain_ing
miswriting1646843miswri_ting
outpainting1445153outpainting
painting113614423___painting
pinpointing1643103pinpointing
repainting13128973_repainting
sainting93215733__s_ainting
splinting1238193__splinting
sprinting12310033__sprinting

Search took 6 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 Filter1786911216330.1561145455.1
2DLD Change Limit121633544.87324960.6
3Display Results54540.0331636.4
 (SQL Overall)178691545.06235300.5
 
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.