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

245 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
trawley1331730(None) 
trawled113411521trawled
trawler104011901trawler
trawleys14284381trawleys
brawled133910122brawled
brawler124310232brawler
brawly144312352brawl_y
crawled133710402crawled
crawler123510462crawler
crawly144610762crawl_y
drawled12368342drawled
drawler11338592drawler
drawly134910722drawl_y
rawly115115832_rawl_y
tawney12338232t_awney
trailed83415672trailed
trailer73015392trailer
trawl84915872trawl__
trawlers113310202trawlers
trawlnet1146582trawlnet
trawls94412392trawl_s
trolley10328752trolley
agley96917333__agley
alley85721673__alley
arable81821003arable_
arables91814983arables
bailey115015673_bailey
barley115116763_barley
bawled124415693_bawled
bawler114315053_bawler
brailed103914013brailed
bravely15428233bravely
brawer114216333braw_er
brawl106217963brawl__
brawlers13408643brawlers
brawlie12198153brawlie
brawlier13267043brawlier
brawls115214333brawl_s
brawny144710603braw_ny
charley15118273charley
craaled10339423craaled
cradle93313163cradle_
cradled113410813cradled
cradler102910513cradler
cradles103114133cradles
crawl104916713crawl__
crawlers13309013crawlers
crawlier13216873crawlier
crawls114712083crawl_s
crawlway1941993crawlway
drably123511613drabl_y
drapey125010583dra_pey
drawee104413823draw_ee
drawees11378363drawees
drawer104711363draw_er
drawl95516013drawl__
drawlers12307313drawlers
drawlier12225253drawlier
drawls105511393drawl_s
frailer10319943frailer
frailly1337313frailly
frailty1335663frailty
galley104215453_galley
grapey126012303gra_pey
gravely14469063gravely
grayly13287963grayl_y
growled12278173growled
growler11318973growler
growly13499173growl_y
hawkey19507633_hawkey
irately1047683irately
kraaled12254983kraaled
oracle84313293oracle_
oracles93212423oracles
orally93113593ora_lly
orangey11388833orangey
parley116718363_parley
parsley1247803parsley
prawned1346743prawned
prawner1246803prawner
prowled13309913prowled
prowler123310013prowler
railed74727543_railed
railer64524933_railer
rale45050563_ra_le_
rales54947493_ra_les
rally84725903_ra_lly
rallye95110163_rallye
rarely93513653_rarely
rawer84623733_raw_er
ridley10169543_ridley
riley84420583_r_iley
sawney12387603_sawney
scrawled1445923scrawled
scrawler1345893scrawler
scrawly15197193scrawl_y
shaley123714993sha_ley
shawled1437773shawled
sprawled1434523sprawled
sprawler1334653sprawler
sprawly15166043sprawl_y
strawed114813623straw_ed
strawier1137493strawier
strawy1210312823straw__y
table75429603t_able_
tabled94020043t_abled
tables84524893t_ables
tablet84227643t_ablet
tackey154613083t_ackey
tailed74424663t_ailed
tailer63823733t_ailer
tale46154163t_a_le_
taler56034873t_a_ler
tales55451373t_a_les
talky126215683t_a_lky
taller63721963t_aller
tally84526863t_a_lly
tamely113711953t_amely
tartlet72218483tartlet
tartly96014023tartl_y
tarweed1137343tarweed
tawdry13395253t_awdry
tawed95926193t_aw_ed
tawer85223443t_aw_er
tawie84819813t_awie_
tawneys13324773t_awneys
tawny114713653t_aw_ny
tawse85616503t_awse_
tawsed10499743t_awsed
tawses94913193t_awses
teazle15329553teazle_
teazled17326833teazled
teazles16308923teazles
thaler94613103tha_ler
thalweg1442033thalweg
thawed13458463thaw_ed
thawer12489343thaw_er
thawless1434083thawless
thralled1245803thralled
thrawed1435593thraw_ed
thrawnly1741793thrawnly
tomalley1343283tomalley
trace75829613tra_ce_
traced94821583tra_ced
tracer84820233tra_cer
tracery12399793tracery
traces85329933tra_ces
trachea12311683trachea
trachle12311853trachle_
trachled1438313trachled
trachles13311753trachles
tracked143716133tracked
tracker133515173tracker
trade65026043tra_de_
traded85717683tra_ded
trader75218763tra_der
trades75724503tra_des
tragedy1234793tragedy
traiked123310453traiked
trail55126773trail__
trailers82912933trailers
trails64622513trail_s
trained84117203trained
trainee72817793trainee
trainer73316793trainer
tramel84113713tra_mel
trameled11309073trameled
tramell9398703tramell
tramels93812493tramels
tramless1037503tramless
trammed123810713trammed
trammel11357663trammel
tramped124312433tramped
tramper113812163tramper
trample11299703trample_
trampled13247903trampled
trampler12278013trampler
tramples122610203tramples
trampy13499253tra_mpy
tramway1544863tramway
trance84718763trance_
tranced104414173tranced
trances93919643trances
tranny94210863tra_nny
trapes85024463tra_pes
trapped124512213trapped
trapper113912803trapper
trashed113514703trashed
trasher104416133trasher
trashes104119263trashes
trashy12509053tra_shy
trasses74819323trasses
trave85223033tra_ve_
travel94112983tra_vel
traveled12349453traveled
traveler11328433traveler
travels104711293travels
traves94222743tra_ves
trawling122710783trawling
trawlnets1242843trawlnets
tray77632593tra___y
treacle939973treacle_
treacles1039703treacles
treacly1237093treacl_y
treadle8310103treadle_
treadled1067123treadled
treadler936863treadler
treadles939703treadles
treble8311663treble_
trebled1038483trebled
trebles9311443trebles
trebly1138973trebl_y
trey77228793tr___ey
triable92515393triable_
trifle94012883trifle_
trifled113711963trifled
trifler103912153trifler
trifles103814833trifles
trigly103810943trigl_y
trilby1144973tr_ilby
trilled84116313trilled
triller74215893triller
trimly114410893triml_y
triolet73219533triolet
triple84215923triple_
tripled104113833tripled
triples94616873triples
triplet94319213triplet
triplex16447803triplex
triply114211023tripl_y
tritely1039003tritely
trolled84312263trolled
troller73913173troller
trolleys11315693trolleys
trolly94012363tr_olly
trowed104714653trow_ed
trowel94211463trow_el
troweled12106113troweled
troweler11106063troweler
trowels10358363trowels
truly84111553tr_ul_y
valley124311603_valley
wawled133811703_wawled
yawey14458273_yaw_ey
yawled13459983_yawled

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272456.76319817.7
3Display Results2452450.0803062.5
 (SQL Overall)1786912457.24924650.4
 
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.