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

166 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
troweled1210611(None) 
roweled11269861_roweled
toweled112410221t_oweled
troweler11106061troweler
trowelled1344441trowelled
boweled132810692_boweled
doweled12269772_doweled
groveled13345452groveled
growled12278172grow_led
prowled13309912prow_led
rowelled1236632_rowelled
towelled1236352t_owelled
towered112911402t_owered
trameled11309072trameled
traveled12349452traveled
trawled113411522traw_led
trolled84312262tro_lled
troubled1134982troubled
trowed104714652trow__ed
trowel94211462trowel__
trowelers12105262trowelers
troweller1244562troweller
trowels10358362trowel_s
bowelled1446173_bowelled
bowered133113043_bowered
bowled125018143_bow_led
brawled133910123braw_led
broiled103811423bro_iled
brokered1536083brokered
browed125216393brow__ed
browned134710973brow_ned
browsed134511233brow_sed
corbeled1338373corbeled
cowered133214653_cowered
cowled125218393_cow_led
crawled133710403craw_led
creeled104012013cr_eeled
creneled11326893creneled
crowded14418793crow_ded
crowed124717303crow__ed
crowned133912433crow_ned
dowelled1356343_dowelled
dowered122811553_dowered
drawled12368343draw_led
driveled1374973driveled
drolled93810223dro_lled
drooled9369203dro_oled
drownded14334433drownded
drowned12419903drow_ned
drowsed12448743drow_sed
emboweled1743223emboweled
flowered1546013flowered
fowled133914103_fow_led
frogeyed1642783frogeyed
frowned14348833frow_ned
frowsted1534313frowsted
glowered1345753glowered
graveled13417363graveled
groveler12305843groveler
grovelled1454183grovelled
growler11318973grow_ler
grueled937133gr_ueled
hoveled14209293_hoveled
howled134014973_how_led
ironweed1244053ironwe_ed
jeweled1845333_jeweled
jowled174210803_jow_led
lowered112711913_lowered
modeled1139463_modeled
morseled1147193morseled
powered132911643_powered
proceed12310553proce_ed
profiled14338523profiled
propelled1456913propelled
prowler123310013prow_ler
raveled114113633_raveled
reeled74725533_r_eeled
reveled113917753_reveled
reweld103711113_rewel_d
rewelded1335893_rewelded
rodeoed937883_rodeoed
rogered939553_rogered
roiled74320053_ro_iled
rolled74220243_ro_lled
rootled83410533_rootled
rowed94034323_row__ed
rowel84721413_rowel__
rowels94515453_rowel_s
scowled13398193scow_led
shoveled15195353shoveled
showered1537013showered
streeled9267863str_eeled
strolled937813stro_lled
strowed115312143strow__ed
tarweed1137343tarwe_ed
tasseled935593tasseled
teaseled9186793teaseled
teazeled18194233teazeled
tholed105113873tho__led
throttled1352963throttled
tinseled935763tinseled
toddled10328823t_oddled
toggled10428653t_oggled
toiled74420323t_o_iled
tokened1236393t_okened
toled65934923t_o__led
tolled73819033t_o_lled
tooled74918903t_o_oled
tootled83511043t_ootled
toppled12348843t_oppled
totaled839693t_otaled
tousled84710363t_ousled
touzled17367153t_ouzled
towed95134583t_ow__ed
towel84920523t_owel__
towels94314643t_owel_s
townlet1049733t_ownlet
trachled1438313trachled
trailed83415673tr_ailed
tramelled1266223tramelled
trammeled1453203trammeled
trampled13247903trampled
trapesed1136473trapesed
traveler11328433traveler
travelled1356863travelled
trawler104011903traw_ler
trawley13317303traw_ley
treadled1067123treadled
trebled1038483tr_ebled
treddled1134473treddled
treed65626733tr__e_ed
trembled1335253trembled
trickled152610433trickled
trifled113711963tr_ifled
trilled84116313tr_illed
trindled10388693trindled
tripled104113833tr_ipled
troaked12438253tro_aked
trochlea1345193trochlea
trocked144312243tro_cked
troked114114583tro__ked
troller73913173tro_ller
trolley10328753tro_lley
trolleyed1342473trolleyed
trollied935893trollied
tromped124210293tro_mped
trooped104010723tro_oped
trophied1437643trophied
trothed114010973tro_thed
trotted83711283tro_tted
trouble957713trouble_
troubler1035293troubler
troubles1057203troubles
trounced1135033trounced
trouped103910983tro_uped
troweling1376363troweling
trowellers1343663trowellers
truckled15327313truckled
truffled1563993truffled
trundled10306393trundled
tunneled955233tunneled
tweed94915093t__we_ed
urodele845963urodele_
urodeles945563urodeles
yodeled1236863_yodeled
yowled133811093_yow_led

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 Limit1461621666.78021557.8
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.26624592.8
 
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.