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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
scrambled1616481(None) 
scrabbled16154971scrabbled
scramble14177251scramble_
scrambler15165041scrambler
scrambles15146381scrambles
brambled15316732_brambled
crumbled15357442_crumbled
rambled123913522__rambled
scabbled15156302sc_abbled
scrabble14196992scrabble_
scrabbler15195202scrabbler
scrabbles15206282scrabbles
scramblers16183542scramblers
scrammed1555002scram_med
scrawled1445922scra_wled
scribbled16174032scribbled
scumbled1535052sc_umbled
shambled16156152s_hambled
unscrambled1861712unscrambled
ambled115116373___ambled
brabbled12337633_brabbled
bramble133710033_bramble_
brambles14308973_brambles
cabled114819873_c_a_bled
craaled10339423_cra_aled
crabbed14388873_cra_bbed
crackled17428863_crackled
cradled113410813_cra_dled
crambe1239073_cramb_e_
crambes1339963_cramb_es
cramboes1436543_cramboes
crammed143710123_cram_med
cramped144712183_cram_ped
crankled15408153_crankled
crawled133710403_cra_wled
cribbled15305803_cribbled
crimpled15366933_crimpled
crumbed14378473_crumb_ed
crumble133410403_crumble_
crumbles14329683_crumbles
crumpled15296873_crumpled
drabbled14367053_drabbled
drumbled14266033_drumbled
gambled134112163__gambled
grabbled14327373_grabbled
grumbled14256753_grumbled
preambled1643893preambled
rabbled123514423__rabbled
ramble104519973__ramble_
rambler113313263__rambler
rambles113118313__rambles
rumbled124514593__rumbled
sambaed1238303s__ambaed
sampled123410793s__ampled
scabbed14408223sc_a_bbed
scabble13168653sc_abble_
scabbles14167983sc_abbles
scaled94822443sc_a__led
scammed14479543sc_am_med
scamped144711963sc_am_ped
scrabblers16213813scrabblers
scrabblier1642773scrabblier
scrabbly17164623scrabbl_y
scragged1335823scra_gged
scraiched1744203scraiched
scraighed1643593scraighed
scrambling1743473scrambling
scramjet1945033scram_jet
scraped124313133scra__ped
scrapped1556533scra_pped
scrapple1434683scrapple_
scrapples1534803scrapples
scratched1735393scratched
scrawler1345893scra_wler
screamed13277603scream__ed
scribble14175433scribble_
scribbler15164223scribbler
scribbles15184953scribbles
scribed124510643scr_ib_ed
scrimped1555313scrim_ped
scrolled1137053scr_olled
scrubbed1533853scr_ubbed
scrummed1554313scrum_med
scrupled1335823scr_upled
scumble1337013sc_umble_
scumbles1447023sc_umbles
shamble14149263s_hamble_
shambles15159043s_hambles
spraddled14203463spraddled
sprattled1263313sprattled
sprawled1434523spra_wled
squabbled2342563squabbled
stabled103514953s_ta_bled
straddled12205023straddled
straggled12296853straggled
strangled11268983strangled
streambed1483333streamb_ed
stumbled1335623s_tumbled
trameled11309073_trameled
trampled13247903_trampled
trembled1335253_trembled
unscramble1652983unscramble_
unscrambler1761453unscrambler
unscrambles1761703unscrambles
wambled153610753__wambled

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411056.34323433.9
3Display Results1051050.0303500.0
 (SQL Overall)1786911056.79626293.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.