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

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
blackhander236302(None) 
backhander22144941b_ackhander
blackhanders2462401blackhanders
backhanded23114662b_ackhanded
backhanders23123802b_ackhanders
backhand2047433b_ackhand__
backhands2146303b_ackhand_s
blackbirder2251923blackbirder
blackener1754973black_en_er
blackland1844653blackland__
blacklands1944123blackland_s
blackmailer2152063blackmailer
blackwater21103973blackwa_ter
blockader1843113block_a_der
bacchante1844654b_acchante_
bacchantes1944424b_acchantes
backhandedly2861244b_ackhandedly
backhanding2453764b_ackhanding
backhauled2253254b_ackhauled
backland1748104b_ackland__
backlands1846824b_ackland_s
backlasher21124484b_acklasher
backpacker2153934b_ackpacker
backslider1944194b_ackslider
backwater2096754b_ackwa_ter
barehanded1743444b_arehanded
blackamoor2071784black_amoor
blackballed2252304blackballed
blackbirded2351804blackbirded
blackbirders2351504blackbirders
blackened1845274black_en_ed
blackeners1844124black_en_ers
blacker154513514black____er
blackface2243424blackfa_ce_
blackfaces2343564blackfa_ces
blackguarded2361534blackguarded
blackhead2184304blackhead__
blackheads2264114blackhead_s
blackjacked2852074blackjacked
blacklister1952264blacklister
blackmailed2252014blackmailed
blackmailers2251674blackmailers
blacksnake1752494blacksnake_
blacksnakes1852534blacksnakes
blackwaters22103144blackwa_ters
blander103715164bl____ander
blockade1744034block_a_de_
blockaded1943084block_a_ded
blockaders1942574block_a_ders
blockades1844114block_a_des
flatlander1452454fla_tlander
jackhammer3051884_jackhammer
placeholder1952554placeholder
slackener1543934slack_en_er
stickhandler226724stickhandler

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 Filter1786911488190.423422437.4
2DLD Change Limit148819559.28316031.3
3Display Results55550.0301833.3
 (SQL Overall)178691559.73618353.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.