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

134 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
scrawlers143475(None) 
crawlers13309011_crawlers
scrawler1345891scrawler_
sprawlers1433901sprawlers
brawlers13408642_brawlers
cradlers11309202_cradlers
crawler123510462_crawler_
drawlers12307312_drawlers
scalers93817262sc_a_lers
scowlers13257372sc_owlers
scrabblers16213812scrabblers
scramblers16183542scramblers
scrapers125510532scra_pers
scrappers1545862scrappers
scrawled1445922scrawle_d
scrawlier1443902scrawlier_
scrawls12177282scrawl__s
screwers13358062screw_ers
sprawler1334652sprawler_
trawlers113310202_trawlers
bawlers124412733__bawlers
brawler124310233_brawler_
cablers114416713_c_ablers
callers94221963_c_allers
carolers103314173_carolers
chawers154412053_chaw_ers
clawers123910973_claw_ers
clawless1334123_clawless
coalers94419353_coa_lers
crabbers14358753_crabbers
crackers164111723_crackers
cradler102910513_cradler_
cradles103114133_cradle_s
crafters13419953_crafters
crammers14369353_crammers
crappers144011023_crappers
crashers134013233_crashers
craters95021893_cra_ters
cravers124416563_cra_vers
crawled133710403_crawle_d
crawlier13216873_crawlier_
crawls114712083_crawl__s
crewless1335413_crewless
crowders14398813_crowders
crowers124614903_crow_ers
crowners133710753_crowners
crullers1047303_crullers
drawers113610073_draw_ers
drawler11338593_drawler_
growlers12327093_growlers
prawners1346003_prawners
prowlers13328933_prowlers
railers74420663__railers
sailers73822323s__ailers
sawers94620163s__aw_ers
sawyers13317533s__awyers
scalars93711903sc_a_lars
scaler84321603sc_a_ler_
scales84529313sc_a_le_s
scalpers123710863sc_alpers
scammers14339773sc_ammers
scampers143611033sc_ampers
scanners10379703sc_anners
scarers94618513sc_a_rers
scarfers13408463sc_arfers
scarless10189053sc_arless
scarlets10178573sc_arlets
scarpers124712513sc_arpers
scatters103612753sc_atters
scaupers12378173sc_aupers
schillers14285663schillers
sclaffers17122523sclaffers
scowders14276233sc_owders
scowler12248193sc_owler_
scrabbler15195203scrabbler_
scrabbles15206283scrabble_s
scrambler15165043scrambler_
scrambles15146383scramble_s
scramjets2052063scramjets
scrannels1143513scrannels
scraper114513423scra_per_
scrapes116217663scra_pe_s
scrapies124612493scrapie_s
scrapper1466973scrapper_
scrapples1534803scrapple_s
scratchers1744293scratchers
scrawl11208093scrawl___
scrawliest1553823scrawliest
scrawling15195583scrawling
scrawly15197193scrawl__y
scrawnier1443643scrawnier_
screamers13236263screamers
screeners1136733screeners
screwer124410073screw_er_
screwier1346433screwier_
scribblers16183103scribblers
scribers12307963scr_ibers
scrimpers1554643scrimpers
scripters13116683scripters
scrubbers1543373scrubbers
scruples1237433scruple_s
scufflers17285033scufflers
scullers103510483sc_ullers
sealers74323553s_ea_lers
snarlers8298753s_narlers
spallers102910733s_pallers
sparklers15315643sparklers
spawners13396493s_pawners
sprawled1434523sprawle_d
sprawlier1443293sprawlier_
sprawls12176373sprawl__s
sprayers13367053spra_yers
squallers1834683squallers
squawkers2542483squawkers
stablers103611153s_tablers
staplers103111203s_taplers
startlers9236743startlers
stealers83412213stea_lers
straddlers12203823straddlers
strafers11379913stra_fers
stragglers12305253stragglers
strainers9510383strainers
stranders10389933stranders
strangers104112163strangers
stranglers11396823stranglers
strapless1135793strapless
strappers1346743strappers
strawier1137493strawier_
strayers113510143stra_yers
strewers11409063strew_ers
strollers937553strollers
trailers82912923_trailers
trawler104011903_trawler_
trawleys14284383_trawleys

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411347.14320809.3
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.62523434.9
 
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.