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

73 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
scrabblers1621381(None) 
scrabbler15195201scrabbler_
scrabbles15206281scrabble_s
scramblers16183541scramblers
scribblers16183101scribblers
brabblers12335562_brabblers
crabbers14358752_crabb_ers
grabblers14345512_grabblers
rabblers123810852__rabblers
scabbles14167982sc_abble_s
scrabble14196992scrabble__
scrabbled16154972scrabble_d
scrabblier1642772scrabblier_
scrambler15165042scrambler_
scrambles15146382scramble_s
scrawlers1434752scra_wlers
scribbler15164222scribbler_
scribbles15184952scribble_s
scrubbers1543372scrubb_ers
squabblers2341842squabblers
babblers113510353__babblers
brabbler11397373_brabbler_
brabbles11349753_brabble_s
cablers114416713_c_a_blers
clabbers14359903_clabb_ers
cobblers14359593_c_obblers
crabber133810733_crabb_er_
crabbier14326803_crabbier_
cradlers11309203_cra_dlers
crawlers13309013_cra_wlers
cribbers14306443_cribb_ers
dabblers13379363__dabblers
drabbles13308523_drabble_s
dribblers14274453_dribblers
fribblers16314193_fribblers
gabblers134110083__gabblers
grabbers13337883_grabb_ers
grabbler13377693_grabbler_
grabbles13339893_grabble_s
rabbler113514093__rabbler_
rabbles113517973__rabble_s
ramblers124010373__ramblers
scabbier1435133sc_abbier_
scabble13168653sc_abble__
scabbled15156303sc_abble_d
scalers93817263sc_a__lers
scrabbliest1742483scrabbliest
scrabbling1742853scrabbling
scrabbly17164623scrabbl__y
scramble14177253scramble__
scrambled16164813scramble_d
scrapers125510533scra__pers
scrappers1545863scra_ppers
scrapples1534803scrapple_s
scratchers1744293scratchers
scrawler1345893scra_wler_
scribble14175433scribble__
scribbled16174033scribble_d
scribers12307963scr_ib_ers
scrubber1434123scrubb_er_
scrubbier1543333scrubbier_
slabbers123610123s_labb_ers
sprawlers1433903spra_wlers
squabbler2242733squabbler_
squabbles2243633squabble_s
stabbers12268733s_tabb_ers
stablers103611153s_ta_blers
straddlers12203823straddlers
stragglers12305253stragglers
stranglers11396833stranglers
swabbers15316743s_wabb_ers
unscramblers1891003unscramblers
wabblers15398993__wabblers

Search took 8 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.403443402.0
2DLD Change Limit140603737.04619955.0
3Display Results73730.0332212.1
 (SQL Overall)178691737.48223882.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.