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

163 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
sprawler133465(None) 
scrawler1345891scrawler
sprawled1434521sprawled
sprawlers1433901sprawlers
sprawlier1443291sprawlier
brawler124310232_brawler
crawler123510462_crawler
drawler11338592_drawler
prawner1246802_prawner
prowler123310012_prowler
scrawled1445922scrawled
scrawlers1434752scrawlers
scrawlier1443902scrawlier
spaller92713472sp_aller
sparkler14317982sparkler
spawner12347362sp_awner
sprawl11188062sprawl__
sprawls12176372sprawl_s
sprawly15166042sprawl_y
sprayer12369042spra_yer
strawier1137492strawier
trawler104011902_trawler
bawler114315053__bawler
brawer114216333_braw_er
brawled133910123_brawled
brawlers13408643_brawlers
brawlier13267043_brawlier
cradler102910513_cradler
crawled133710403_crawled
crawlers13309013_crawlers
crawlier13216873_crawlier
drawer104711363_draw_er
drawled12368343_drawled
drawlers12307313_drawlers
drawlier12225253_drawlier
frailer10319943_frailer
growler11318973_growler
paler75436933_p_a_ler
pawer104422973_p_aw_er
pawner114212923_p_awner
pearler9310373_pearler
praiser93413943_praiser
prancer113613383_prancer
prater84825353_pra_ter
prattler10166343_prattler
prawned1346743_prawned
prawners1346013_prawners
prayer114815293_pra_yer
prower114218123_prow_er
prowled13309913_prowled
prowlers13328933_prowlers
railer64524933__railer
rawer84623733__raw_er
sailer63526103s__ailer
sawer85026213s__aw_er
sawyer12438043s__awyer
scaler84321603s_ca_ler
scowler12248193s_cowler
scrabbler15195203scrabbler
scrambler15165043scrambler
scraper114513423scra_per
scrapper1466973scrapper
scrawl11208093scrawl__
scrawls12177283scrawl_s
scrawly15197193scrawl_y
scrawnier1443643scrawnier
screwer124410073screw_er
screwier1346433screwier
sealer63928963s_ea_ler
shawled1437773s_hawled
shoaler102610083shoa_ler
shrewder1534403shrewder
shriller1136823shriller
smaller93410333s_maller
snarler73610633s_narler
spacer104917793sp_a_cer
spacier114011633sp_acier
spader94317133sp_a_der
spale74929213sp_a_le_
spales84728103sp_a_les
spalled103113133sp_alled
spallers102910733sp_allers
spammer133410433sp_ammer
spanker133612353sp_anker
spanner94312563sp_anner
sparable121611983sparable_
sparables13167173sparables
sparer84524963sp_a_rer
sparger103613083sp_arger
sparker133914363sp_arker
sparkier14298033sparkier
sparkle133710213sparkle_
sparkled15317733sparkled
sparklers15315643sparklers
sparkles143210493sparkles
sparklet143110593sparklet
sparklier1554363sparklier
sparrier10329143sparrier
sparser94311483sp_arser
spatter94016523sp_atter
spawned13316803sp_awned
spawners13396493sp_awners
speaker133311213spea_ker
spearer93913663spea_rer
speller95415153sp_eller
spewer115112153sp_ew_er
spieler93111233sp_ieler
spiller92914333sp_iller
spindler11297983spindler
spiracle1255803spiracle_
spiracles1345663spiracles
spiraled1137733spira_led
spiralled1244403spiralled
splasher1335663splasher
splatter10348883splatter
spoiler93310683sp_oiler
spooler93711383sp_ooler
spraddle12194163spraddle_
spraddled14203463spraddled
spraddles13194283spraddles
sprained1138433sprained
sprattle1054763sprattle_
sprattled1263313sprattled
sprattles1174883sprattles
sprawliest1543583sprawliest
sprawling15175123sprawling
sprayed13398903spra_yed
sprayers13367053spra_yers
spreader1137483spreader
sprier84119063spr__ier
sprigger12366503sprigger
springer113311753springer
sprinkler1543573sprinkler
sprinter103810813sprinter
spritzer1944563spritzer
sprucer11317683spr_ucer
sprucier1254793sprucier
spryer11418533spr__yer
squaller1736083squaller
squawker2443093squawker
stabler94014933s_tabler
staler64025823s_ta_ler
stapler93913633s_tapler
startler8248793startler
stealer72913983stea_ler
straddler11205113straddler
strafer103912463stra_fer
straggler11377293straggler
strainer8512223strainer
straiter8311783straiter
strander97112063strander
stranger94715103stranger
strangler10369473strangler
strapper1258093strapper
strawed114813623straw_ed
strayer104312503stra_yer
strewer104310413strew_er
stroller848183stroller
trailer73015393_trailer
trawled113411523_trawled
trawlers113310203_trawlers
trawley13317303_trawley
upraiser10175843upraiser

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621638.03018202.0
3Display Results1631630.0632587.3
 (SQL Overall)1786911638.51620983.0
 
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.