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

187 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
scrawler134589(None) 
crawler123510461_crawler
scrawled1445921scrawled
scrawlers1434751scrawlers
scrawlier1443901scrawlier
sprawler1334651sprawler
brawler124310232_brawler
cradler102910512_cradler
crawled133710402_crawled
crawlers13309012_crawlers
crawlier13216872_crawlier
drawler11338592_drawler
scaler84321602sc_a_ler
scowler12248192sc_owler
scrabbler15195202scrabbler
scrambler15165042scrambler
scraper114513422scra_per
scrapper1466972scrapper
scrawl11208092scrawl__
scrawls12177282scrawl_s
scrawly15197192scrawl_y
scrawnier1443642scrawnier
screwer124410072screw_er
screwier1346432screwier
sprawled1434522sprawled
sprawlers1433902sprawlers
sprawlier1443292sprawlier
strawier1137492strawier
trawler104011902_trawler
bawler114315053__bawler
becrawled1743123becrawled
brawer114216333_braw_er
brawled133910123_brawled
brawlers13408643_brawlers
brawlier13267043_brawlier
cabler104519173_c_abler
caller85125483_c_aller
caroler93816753_caroler
chawer144314413_chaw_er
clawer114512783_claw_er
coaler84121713_coa_ler
craaled10339423_craaled
crabber133810733_crabber
cracker153114173_cracker
cradle93313163_cradle_
cradled113410813_cradled
cradlers11309203_cradlers
cradles103114133_cradles
crafter124111333_crafter
crammer134010963_crammer
cranker133612793_cranker
crapper133913193_crapper
crasher124616163_crasher
crasser94114343_crasser
crater85026643_cra_ter
craver114618473_cra_ver
crawl104916713_crawl__
crawls114712083_crawl_s
crawly144610763_crawl_y
crazier183610743_crazier
crowder13389863_crowder
crower114117563_crow_er
crowner124012603_crowner
crueler939023_crueler
cruller968753_cruller
drawer104711363_draw_er
drawled12368343_drawled
drawlers12307313_drawlers
drawlier12225253_drawlier
frailer10319943_frailer
growler11318973_growler
prawner1246803_prawner
prowler123310013_prowler
railer64524933__railer
rawer84623733__raw_er
sailer63526103s__ailer
sawer85026213s__aw_er
sawyer12438043s__awyer
scalar83612433sc_a_lar
scale74629143sc_a_le_
scaled94822443sc_a_led
scalers93817263sc_a_lers
scales84529313sc_a_les
scalier94316913sc_alier
scalper113912923sc_alper
scammer133611973sc_ammer
scamper134613163sc_amper
scanner94411813sc_anner
scanter94215183sc_anter
scarcer113911373sc_arcer
scareder1135793scareder
scarer84524613sc_a_rer
scarfer124511083sc_arfer
scarier94017873sc_arier
scarlet91516943sc_arlet
scarper114814823sc_arper
scarrier10298453scarrier
scatter93815173sc_atter
scauper11379453sc_auper
schiller13296473schiller
sclaffer16112653sclaffer
scowder13286873sc_owder
scowled13398193sc_owled
scowlers13257373sc_owlers
scrabble14196993scrabble_
scrabbled16154973scrabbled
scrabblers16213813scrabblers
scrabbles15206283scrabbles
scrabblier1642773scrabblier
scragged1335823scragged
scraggier1344133scraggier
scragglier1442283scragglier
scramble14177253scramble_
scrambled16164813scrambled
scramblers16183543scramblers
scrambles15146383scrambles
scramjet1945033scramjet
scrammed1555003scrammed
scrannel1044033scrannel
scrape105917573scra_pe_
scraped124313133scra_ped
scrapers125510533scra_pers
scrapes116217663scra_pes
scrapie115010943scrapie_
scrapies124612473scrapies
scrapped1556533scrapped
scrappers1545863scrappers
scrappier1544423scrappier
scrapple1434683scrapple_
scrapples1534793scrapples
scratcher1635443scratcher
scrawliest1553813scrawliest
scrawling15195583scrawling
scrawny15213943scraw_ny
screamer12267883screamer
screener1037573screener
screwed135710663screw_ed
screwers13358063screw_ers
scribbler15164223scribbler
scriber113910973scr_iber
scrimper1455763scrimper
scripter12137783scripter
scrolled1137053scrolled
scrubber1434123scrubber
scruple1137193scruple_
scrupled1335823scrupled
scruples1237433scruples
scuffler16286703scuffler
sculler99812153sc_uller
sealer63928963s_ea_ler
shawled1437773s_hawled
shoaler102610083shoa_ler
shrewder1534403shrewder
shriller1136823shriller
smaller93410333s_maller
snarler73610633s_narler
spaller92713473s_paller
sparkler14317983sparkler
spawner12347363s_pawner
sprawl11188063sprawl__
sprawls12176373sprawl_s
sprawly15166043sprawl_y
sprayer12369043spra_yer
squaller1736083squaller
squawker2443093squawker
stabler94014933s_tabler
staler64025823s_ta_ler
stapler93913633s_tapler
startler8248793startler
stealer72913973stea_ler
straddler11205113straddler
strafer103912463stra_fer
straggler11377293straggler
strainer8512223strainer
straiter8311783straiter
strander97112063strander
stranger94715103stranger
strangler10369473strangler
strapper1258093strapper
strawed114813613straw_ed
strayer104312503stra_yer
strewer104310413strew_er
stroller848173stroller
trailer73015393_trailer
trawled113411523_trawled
trawlers113310203_trawlers
trawley13317303_trawley

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621877.11020557.2
3Display Results1871870.0762460.5
 (SQL Overall)1786911877.60923484.2
 
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.