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

324 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
trowsers1142800(None) 
browsers13449201browsers
trousers83910631trousers
arousers84810982arousers
browser124911142browser_
browses124712692browse_s
crossers103912702crossers
crowders14398812crowders
crowers124614902crow_ers
crowners133710752crowners
dowsers115013532_dowsers
drowners12428272drowners
drowses114610232drowse_s
frowners14377932frowners
grossers94410972grossers
grousers93810732grousers
growers113612722grow_ers
growlers12327092growlers
prosers94219642pro_sers
prowlers13328932prowlers
roosers74217882_roosers
rousers75220142_rousers
rowers94924572_row_ers
throwers14106032throw_ers
throwsters1642712throwsters
tossers74713502t_ossers
towers94423672t_ow_ers
trawlers113310202trawlers
troffers14125432troffers
trollers83211212trollers
troopers10289442troopers
trotters83310242trotters
troupers10359442troupers
trouser73812472trouser_
trovers103713322tro_vers
trowelers12105262trowelers
trowels10358362trow_els
trussers8348282trussers
wowsers13488762_wowsers
arouser74514423arouser_
arouses74921293arouse_s
avowers1336333avow_ers
blowers124313593blow_ers
bowers115523703_bow_ers
bowlers123715783_bowlers
bowses115718863_bowse_s
bowyers15438733_bowyers
brawlers13408643brawlers
brewers123811063brew_ers
broiders114211193broiders
broilers103210093broilers
brokers133111913bro_kers
bronzers19296983bronzers
brooders112610243brooders
broses86524403bro_se_s
brothers133410833brothers
browless1346653browless
browner124911643browner_
browse115713853browse__
browsed134511233browse_d
bruisers10307953bruisers
carousers1156743carousers
choosers134810883choosers
chousers134610203chousers
chowders17387543chowders
chowses155611283chowse_s
closers94415323clo_sers
clowders14357473clowders
cowers114625533_cow_ers
crawlers13309013crawlers
creasers103612843creasers
croakers14288523croakers
crofters13358903crofters
crooners103911393crooners
croppers143311483croppers
crosiers103312063crosiers
crosser95015463crosser_
crosses94220793crosse_s
crowbars1544443crowbars
crowder13389863crowder_
crower114117563crow_er_
crowner124012603crowner_
crownets13407673crownets
crowsteps1642533crowsteps
crozers184111083cro_zers
croziers19287003croziers
cruisers10438273cruisers
dorsers83516303_dorsers
dosers75723633_do_sers
dossers84516233_dossers
dousers84817273_dousers
dowers104523293_dow_ers
downers113912773_downers
dowser104716083_dowser_
dowses105718303_dowse_s
drawers113610073draw_ers
drawlers12307313drawlers
dressers9359863dressers
droners84114383dro_ners
droppers13318603droppers
drosera836203dro_sera
droseras935883dro_seras
drosses84513823drosse_s
drovers115212643dro_vers
drowner11369803drowner_
drowse105010553drowse__
drowsed12448743drowse_d
drowsier1284903drowsier_
erasers74413943er_asers
eroses65327053ero_se_s
flossers11307863flossers
flowers133413173flow_ers
fowlers133411203_fowlers
frothers14279813frothers
frowner13429683frowner_
frowsier1444893frowsier_
frowsts13426103frows_ts
glossers9319053glossers
glowers113412093glow_ers
greasers93410253greasers
groaners9248503groaners
grocers103511253gro_cers
groomers11388483groomers
groovers12337123groovers
gropers104813853gro_pers
grosser84313143grosser_
grosses84517683grosse_s
groupers11358643groupers
grouser84513693grouser_
grouses84616543grouse_s
grouters95910083grouters
grower104614933grow_er_
growler11318973growler_
hawsers13409483_hawsers
hosers95223973_ho_sers
housers104717823_housers
howlers133312353_howlers
ironers74813553iro_ners
knowers1436353know_ers
losers65123583_lo_sers
lowers94624923_low_ers
momsers113810853_momsers
mossers94116193_mossers
mousers95216443_mousers
mowers113219403_mow_ers
noosers74913933_noosers
owners94210703__owners
plowers123812243plow_ers
poisers94214433_poisers
posers84223973_po_sers
powders134111553_powders
powers113822323_pow_ers
powters124015663_powters
praisers103410833praisers
prawners1346003prawners
pressers103215023pressers
probers113514583pro_bers
prodders1237463prodders
proffers16126593proffers
proggers12258163proggers
promisers13268203promisers
proofers13118363proofers
propers113619033pro_pers
proposers13228523proposers
proser84223463pro_ser_
proses84733473pro_se_s
prospers123012263prospers
prosses94019513prosse_s
provers123817793pro_vers
prower114218123prow_er_
prowess1237903prow_ess
prowler123310013prowler_
raisers73617393_raisers
rasers64526783_r_asers
rinsers73815743_rinsers
risers64624783_r_isers
roamers93713463_roamers
roarers73812743_roarers
roasters83615933_roasters
robbers112814163_robbers
rockers133916553_rockers
rogers74517913_ro_gers
roisters83615553_roisters
rolfers104011813_rolfers
rollers73117473_rollers
rompers113412243_rompers
roofers105013903_roofers
roomers95416413_roomers
rooser63921883_rooser_
rooses65526243_roose_s
roosters83514663_roosters
rooters74522933_rooters
ropers84325903_ro_pers
rosery93813283_ro_sery
roses56445773_ro_se_s
rosets65819953_ro_sets
rosters73727543_rosters
rotters74421393_rotters
rouser65224083_rouser_
rouses65436283_rouse_s
rousters84315683_rousters
routers74822873_routers
rovers95423523_ro_vers
rowels94515453_row_els
rowens94515303_row_ens
rower85430493_row_er_
roysters113610533_roysters
rozzers1535633_rozzers
scowders14276233scowders
scowlers13257373scowlers
showers134612683show_ers
sowers94923443_sow_ers
strewers11409063strew_ers
strokers123910903stro_kers
strollers937553strollers
stroppers1356713stroppers
stroyers11388923stro_yers
tawers94118603t_aw_ers
tawses94913193t_awse_s
teasers75317243t_easers
thawers13428483thaw_ers
thowless1434613thowless
throbbers1643173throbbers
thrower1386993throw_er_
throwster1542953throwster_
toasters83912723t_oasters
tochers123413093t_ochers
toilers74116263t_oilers
tokers104818893t_o_kers
tollers73217463t_ollers
toners64128003t_o_ners
tongers84116013t_ongers
tonners73816403t_onners
toolers74416503t_oolers
tooters73818773t_ooters
tootlers8289503tootlers
tootses72910773tootse_s
topers85025323t_o_pers
toppers113914603t_oppers
torquers17204303torquers
torses64727953t_orse_s
tosser64215663t_osser_
tosses65225393t_osse_s
toters65026363t_o_ters
totters74618733t_otters
tourers73512743t_ourers
touses64229673t_ouse_s
touters74018353t_outers
towels94314643t_ow_els
tower85729203t_ow_er_
towery124012093t_ow_ery
towhees13277793t_owhees
towies93521193t_owie_s
townees10269783t_ownees
toyers95516333t_o_yers
tracers94917843tr_acers
trackers143512853trackers
traders84316953tr_aders
trailers82912923trailers
trainers83114643trainers
trampers123210393trampers
transfers1238053transfers
trappers123711043trappers
trashers113013643trashers
trasses74819323trasse_s
trawler104011903trawler_
trawleys14284383trawleys
treaders93311843treaders
treaters83615843treaters
trekkers1133803trekkers
tressels8367653tressels
tresses73719543tresse_s
trickers143812813trickers
triers64321523tr__iers
triflers113110213triflers
triggers10257843triggers
trillers83613493trillers
trimers94615143tr_imers
trimmers12288913trimmers
trioses75015653triose_s
trippers123210163trippers
trocars959043tro_cars
trochars1377853trochars
trochees132510183trochees
troches123715343troche_s
troffer13125863troffer_
trokes104019263tro_ke_s
troller73913173troller_
trolleys11315693trolleys
trommels12254333trommels
trompes114111623trompe_s
trones65629283tro_ne_s
trooper94210363trooper_
tropes84824353tro_pe_s
trotter73312253trotter_
troublers1135003troublers
trouncers1134803trouncers
trouper93811433trouper_
troupes94112853troupe_s
trouvere1144073trouvere
trouveres1243773trouveres
trouveurs1241643trouveurs
trover95014663tro_ver_
troves94719113tro_ve_s
trowed104714653trow_e_d
trowel94211463trow_e_l
troweler11106063troweler_
trowellers1343663trowellers
trows88826183trow___s
trowths1365023trow_ths
truckers14279013truckers
trudgers10256863trudgers
trusser74010263trusser_
trusses73813643trusse_s
trusters83112263trusters
trysters11298373trysters
tussers74313563t_ussers
twiers95410163t__wiers
twofers1364053two_fers
twyers12497413t__wyers
vowers124317183_vow_ers
wowser125110203_wowser_
wrongers12327773wrongers
yowlers13328923_yowlers

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 Limit1461623246.48322545.4
3Display Results3243240.1262571.4
 (SQL Overall)1786913247.03225411.1
 
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.