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

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
stickhandlers23766(None) 
stickhandler226721stickhandler_
stickhandles227771stickhandle_s
stickhandle216902stickhandle__
stickhandled236672stickhandle_d
stickhandling246713stickhandling
backhanders23123804_backhand_ers
blackhanders2462404blackhand_ers
chandlers15387674___c_handlers
sticklers15227394stick____lers
stockholders22122884stockhold_ers
backhander22144945_backhand_er_
blackhander2363025blackhand_er_
candlers114214105___c__andlers
chandler14358375___c_handler_
chandlery18384425___c_handlery
handlers124014145_____handlers
mishandles1643775_mi_shandle_s
panhandlers1752045__panhandlers
scrimshanders216555scrimshand_ers
sickeners1535735s_ick_en__ers
slickeners1643665slick_en__ers
spindlers12286455spi____ndlers
standers93514305st____and_ers
stickable1745545stick_a_ble__
stickballs1852815stickba__l_ls
stickers142913035stick_____ers
stickiness1635905stick_in__ess
stickler14259575stick____ler_
stickles142512105stick____le_s
stockades1644435stock_a_d_e_s
stockholder21123095stockhold_er_
stockpilers1961915stock__pilers
straddlers12203825st___raddlers
stranders10389935st___rand_ers
stranglers11396825st___ranglers
straphangers1851745straphan_gers
swindlers13306035swi____ndlers
ticklers14339305_tick____lers

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 Filter1786911247900.406440125.6
2DLD Change Limit124790399.23613511.3
3Display Results39390.0301300.0
 (SQL Overall)178691399.67218475.1
 
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.