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

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

39 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
blackhanders246240(None) 
backhanders23123801b_ackhanders
blackhander2363021blackhander_
backhander22144942b_ackhander_
backhanded23114663b_ackhande_d
backhands2146303b_ackhand__s
blackbirders2351503blackbirders
blackeners1844123black_en_ers
blacklands1944123blackland__s
blackmailers2251673blackmailers
blackwaters22103143blackwa_ters
blockaders1942573block_a_ders
bacchantes1944424b_acchante_s
backhand2047434b_ackhand___
backhandedly2861244b_ackhandedly
backhanding2453764b_ackhanding
backlands1846824b_ackland__s
backlashers22123634b_acklashers
backpackers2252884b_ackpackers
backsliders2052784b_acksliders
backwaters2195164b_ackwa_ters
blackamoors2191594black_amoors
blackbirder2251914blackbirder_
blackener1754974black_en_er_
blackfaces2343564blackfa_ce_s
blackheads2264114blackhead__s
blackland1844654blackland___
blacklisters2051744blacklisters
blackmailer2152064blackmailer_
blackness1735664black__n_ess
blacksnakes1852534blacksnake_s
blackwater21103974blackwa_ter_
blockader1843114block_a_der_
blockades1844114block_a_de_s
flatlanders1551984fla_tlanders
jackhammers3151764_jackhammers
placeholders2062364placeholders
slackeners1643424slack_en_ers
stickhandlers237664stickhandlers

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 Filter1786911247900.423422437.4
2DLD Change Limit124790396.11020423.9
3Display Results39390.0162437.5
 (SQL Overall)178691396.54927285.2
 
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.