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

115 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
sprawlers143390(None) 
scrawlers1434751scrawlers
sprawler1334651sprawler_
brawlers13408642_brawlers
crawlers13309012_crawlers
drawlers12307312_drawlers
prawners1346002_prawners
prowlers13328932_prowlers
scrawler1345892scrawler_
spallers102910732sp_allers
sparklers15315642sparklers
spawners13396492sp_awners
sprawled1434522sprawle_d
sprawlier1443292sprawlier_
sprawls12176372sprawl__s
sprayers13367052spra_yers
trawlers113310202_trawlers
bawlers124412733__bawlers
brawler124310233_brawler_
cradlers11309203_cradlers
crawler123510463_crawler_
drawers113610073_draw_ers
drawler11338593_drawler_
growlers12327093_growlers
pawers114818783_p_aw_ers
pawners124311073_p_awners
pearlers1039033_pearlers
praisers103410833_praisers
prancers123210333_prancers
praters94921653_pra_ters
prattlers11195323_prattlers
prawner1246803_prawner_
prayers124212853_pra_yers
prowler123310013_prowler_
railers74420663__railers
sailers73822323s__ailers
sawers94620163s__aw_ers
sawyers13317533s__awyers
scalers93817263s_ca_lers
scowlers13257373s_cowlers
scrabblers16213813scrabblers
scramblers16183543scramblers
scrapers125510533scra_pers
scrappers1545863scrappers
scrawled1445923scrawle_d
scrawlier1443903scrawlier_
scrawls12177283scrawl__s
screwers13358063screw_ers
sealers74323553s_ea_lers
snarlers8298753s_narlers
spacers113813873sp_a_cers
spaders104214473sp_a_ders
spales84728103sp_a_le_s
spaller92713473sp_aller_
spammers14378693sp_ammers
spankers14369863sp_ankers
spanless10247363sp_anless
spanners103710773sp_anners
sparables13167163sparable_s
sparers94519613sp_a_rers
spargers11389733sp_argers
sparkers144111313sp_arkers
sparkler14317983sparkler_
sparkles143210493sparkle_s
sparklets15275843sparklets
spatters103914703sp_atters
spawner12347363sp_awner_
speakers14299453spea_kers
spearers103711143spea_rers
spellers102812763sp_ellers
spewers124210663sp_ew_ers
spielers10319653sp_ielers
spillers103311703sp_illers
spindlers12286453spindlers
spiracles1345663spiracle_s
splashers1445283splashers
splatters11327543splatters
spoilers10238633sp_oilers
spoolers10349363sp_oolers
spraddles13194283spraddle_s
sprattles1174883sprattle_s
sprawl11188063sprawl___
sprawliest1543573sprawliest
sprawling15175123sprawling
sprawly15166043sprawl__y
sprayer12369043spra_yer_
spreaders1236503spreaders
spriggers13325493spriggers
springers12309983springers
sprinklers1642973sprinklers
sprinters11329363sprinters
spritzers2043903spritzers
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
upraisers11174423upraisers

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.486367677.0
2DLD Change Limit1486411156.98321286.1
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.51523777.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.