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

69 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
scramblers1618354(None) 
scrabblers16213811scrabblers
scrambler15165041scrambler_
scrambles15146381scramble_s
ramblers124010372__ramblers
scrabbler15195202scrabbler_
scrabbles15206282scrabble_s
scramble14177252scramble__
scrambled16164812scramble_d
scrawlers1434752scra_wlers
scribblers16183102scribblers
unscramblers1891002unscramblers
amblers115213563___amblers
brabblers12335563_brabblers
brambles14308973_bramble_s
cablers114416713_c_a_blers
cambers134017443_c_amb_ers
chambers173410623_chamb_ers
clambers144211293_clamb_ers
crabbers14358753_cra_bbers
cradlers11309203_cra_dlers
crambes1339963_cramb_e_s
cramboes1436543_cramboe_s
crammers14369353_cram_mers
crawlers13309013_cra_wlers
crumbers14338243_crumb_ers
crumbles14329683_crumble_s
gamblers13369733__gamblers
grabblers14345513_grabblers
grumblers14245023_grumblers
rabblers123810853__rabblers
rambler113313263__rambler_
rambles113118313__ramble_s
rumblers123610743__rumblers
samplers12299403s__amplers
scabbles14167983sc_abble_s
scalers93817263sc_a__lers
scammers14339773sc_am_mers
scampers143611033sc_am_pers
scamsters1334993sc_amsters
scrabble14196993scrabble__
scrabbled16154973scrabble_d
scrabblier1642773scrabblier_
scrambling1743473scrambling
scramjets2052063scram_jets
scrapers125510533scra__pers
scrappers1545863scra_ppers
scrapples1534803scrapple_s
scratchers1744293scratchers
scrawler1345893scra_wler_
screamers13236263scream__ers
scribbler15164223scribbler_
scribbles15184953scribble_s
scribers12307963scr_ib_ers
scrimpers1554643scrim_pers
scrubbers1543373scr_ubbers
scumbles1447023sc_umble_s
shambles15159043s_hamble_s
sprawlers1433903spra_wlers
squabblers2341843squabblers
stablers103611153s_ta_blers
straddlers12203823straddlers
stragglers12305253stragglers
stranglers11396833stranglers
stumblers1334383s_tumblers
tramplers13305883_tramplers
tremblers1334483_tremblers
unscrambler1761453unscrambler_
unscrambles1761703unscramble_s

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.483369960.7
2DLD Change Limit140603697.18619566.2
3Display Results69690.0332090.9
 (SQL Overall)178691697.70223200.6
 
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.