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

427 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
trowels1035836(None) 
rowels94515451_rowels
towels94314641t_owels
trowel94211461trowel_
bowels114315592_bowels
crewels12438482crewels
crowers124614892crowers
dowels104813342_dowels
grovels11427812grovels
growers113612722growers
growls104711112grow_ls
propels113412842propels
prowess1237902prowess
prowls115511082prow_ls
rowel84721412_rowel_
rowens94515302_rowens
rowers94924572_rowers
throwers14106022throwers
towel84920522t_owel_
towers94423672t_owers
tramels93812492tramels
travels104711292travels
trawls94412392traw_ls
trokes104019262troke_s
trolls64613942tro_lls
trommels12254332trommels
trones65629282trone_s
tropes84824352trope_s
trotyls10236032trotyls
trovers103713312trovers
troves94719112trove_s
trowed104714652trowe_d
troweled12106112troweled
troweler11106062troweler
trowelers12105252trowelers
trows88826182trow__s
trowsers11427982trowsers
trowths1365022trowths
vowels124410482_vowels
aerogels945593aerogels
ariels65119373ar_iels
artels66216233ar_tels
avowals1335013avowals
avowers1336333avowers
blowers124313593blowers
bordels103911973bordels
botels84815803_botels
bowel105621203_bowel_
bowers115523703_bowers
bowls106121433_bow_ls
brawls115214333braw_ls
brewers123811053brewers
broils84114173bro_ils
brokers133111913brokers
bromals1139743bromals
bromes104719763brome_s
broses86524403brose_s
brothels13277073brothels
browed125216393browe_d
browless1346653browless
browns116415633brow_ns
brows105425983brow__s
browsers13449193browsers
browses124712693browses
corbels113813593corbels
cormels113813373cormels
cornels94716663cornels
coronels104012143coronels
cowers114625533_cowers
cowls106922213_cow_ls
crawls114712083craw_ls
creels84416943cr_eels
crenels93711013crenels
crewel114310473crewel_
crones84729243crone_s
crores86121163crore_s
crowders14398793crowders
crowds124910763crow_ds
crowed124717293crowe_d
crower114117553crowe_r
crowners133710743crowners
crownets13407673crownets
crowns115615113crow_ns
crows105727313crow__s
crozers184111083crozers
crozes174417663croze_s
dorsels84412573dorsels
dowel95618193_dowel_
dowers104523293_dowers
drawees11378363drawees
drawers113610073drawers
drawls105511393draw_ls
drivels11397923drivels
drolls75312393dro_lls
droners84114383droners
drones75023433drone_s
drools74412813dro_ols
drovers115212643drovers
droves105116673drove_s
drownds12346153drownds
drowners12428273drowners
drowns105612333drow_ns
drowses114610233drowses
drywell1442373drywell
drywells1542113drywells
embowels15224133embowels
erodes74819883erode_s
erosely1038073erosely
eroses65327053erose_s
flowers133413173flowers
fowls115518893_fow_ls
froes86126693fro_e_s
frowners14377933frowners
frowns126011393frow_ns
frows116623103frow__s
frowsts13426093frowsts
glowers113412093glowers
gravels113611143gravels
grocers103511253grocers
gromwell1441843gromwell
gromwells1541743gromwells
gropers104813853gropers
gropes95220403grope_s
grovel104310543grovel_
groves104318103grove_s
grower104614933growe_r
growl96115823grow_l_
growled12278163growled
growler11318973growler
growlers12327093growlers
growly13499173grow_ly
grows95523923grow__s
growths1494423growths
gruels73910153gr_uels
hosels94218603_hosels
hotels94515503_hotels
hovels125413333_hovels
howes114730263_howe_s
howls116219223_how_ls
ironers74813553ironers
irones64724013irone_s
isohels1035393isohels
jewels16508613_jewels
jowls156214523_jow_ls
knawels14344683knawels
knowers1436333knowers
koels94613903_ko_els
krewes1337923krewe_s
losels64714583_losels
lowers94624923_lowers
lowes85732463_lowe_s
models94216353_models
mohels115011323_mohels
morels84820013_morels
morsels94112653morsels
motels83616893_motels
mowers113219403_mowers
newels93710823_newels
noels56418703_no_els
novels95512503_novels
oriels64914623or_iels
owes75137103__owe_s
owls76022933__ow_ls
petronels1146063petronels
plowers123812243plowers
powers113822323_powers
probers113514573probers
probes104119453probe_s
process11310403process
proems104711163pro_ems
profess1237713profess
projets1639163projets
prolegs10379993prolegs
proles84627203prole_s
pronely12310243pronely
propel103714063propel_
propers113619033propers
propyls14308193propyls
prosers94219643prosers
proses84733473prose_s
proteas92015123proteas
proteus92511593proteus
protyls12298463protyls
provers123817793provers
proves114322253prove_s
prower114218123prowe_r
prowest12311533prowest
prowl105615123prow_l_
prowled13309903prowled
prowler123310013prowler
prowlers13328933prowlers
prows106327013prow__s
ratels64518213_ratels
ravels94717073_ravels
rebels84518133_rebels
reels55333263_r_eels
refels94618053_refels
repels84318763_repels
revels94220573_revels
reweds104412303_reweds
reweld103711113_reweld
rewelds11457413_rewelds
rewets94617213_rewets
riels55121333_r_iels
robes75133303_robe_s
robles85321693_robles
rodeos75314503_rodeos
rodes614039083_rode_s
roes45954133_ro_e_s
rogers74517913_rogers
roils54826793_ro_ils
roles56747983_role_s
rolls55326233_ro_lls
romeos84013173_romeos
rondels82510053_rondels
ronnels7318613_ronnels
ropers84325903_ropers
ropes75940063_rope_s
roses56445773_rose_s
rosets65819953_rosets
rotes56143903_rote_s
rotls55620163_ro_tls
rouens64814443_rouens
roues56039353_roue_s
rovers95423523_rovers
roves84834483_rove_s
rowans95715343_rowans
rowed94034323_rowe_d
roweled11269863_roweled
rowen84921153_rowe_n
rower85430493_rowe_r
rows75941753_row__s
rowths12458173_rowths
royals93711263_royals
rubels84112993_rubels
scowls11549593scow_ls
shovels13378383shovels
showers134612663showers
sorels63921163_sorels
sorrels7310713sorrels
sowens93613153_sowens
sowers94923433_sowers
streels73811343str_eels
strewers11409053strewers
strobes93813263strobe_s
strobils1046563strobils
strokers123910893strokers
strokes114316323stroke_s
strolls739183stro_lls
strowed115312143strowe_d
strows96718273strow__s
stroyers11388913stroyers
strudels934123strudels
taels56822073t__aels
tassels74510853tassels
tawers94118603t_awers
teasels74311313teasels
teazels16406883teazels
teels55726373t__eels
tels46841693t___els
tercels94110363tercels
thawers13428483thawers
tholes94919783thole_s
thowless1434613thowless
throes97518673thro_e_s
thrones105715843throne_s
thrower1386993throwe_r
throws129715233throw__s
tinsels738373tinsels
toeas55726423t_o_eas
toes46956443t_o_e_s
toiles63923513t_oiles
toils54527493t_o_ils
tokens104711563t_okens
tokers104818893t_okers
tokes95234973t_oke_s
toles55147133t_ole_s
tolls54728433t_o_lls
tolyls9436963t_olyls
tomes76037383t_ome_s
toners64128003t_oners
tones56048663t_one_s
toolers74416503toolers
tools55325243t_o_ols
tooters73818773tooters
tootles72915603tootles
topees85519703t_opees
topers85025323t_opers
topes76941763t_ope_s
tores55352673t_ore_s
tories65435883torie_s
torses64727953torse_s
tortes64826053torte_s
totals63115163t_otals
totems86810763t_otems
toters65026363t_oters
totes55139683t_ote_s
towed95134583t_owe_d
toweled112410223t_oweled
tower85729203t_owe_r
towery124012093t_owery
towhees13277793t_owhees
towies93521193t_owies
townees10269783t_ownees
towns86018883t_ow_ns
tows78545553t_ow__s
toyers95516333t_oyers
tracers94917833tracers
traces85329933trace_s
traders84316943traders
trades75724493trade_s
trails64622513tr_ails
tramel84113713tramel_
tramell9398703tramell
tramells10327833tramells
trammels12295413trammels
trapes85024463trape_s
travel94112983travel_
traves94222743trave_s
trawl84915873traw_l_
trawled113411523trawled
trawler104011903trawler
trawlers113310193trawlers
trawley13317303trawley
trawleys14284383trawleys
trebles9311443trebles
treens65317873tr_eens
trees55835763tr__ees
treks96016853tr__eks
tres46542903tr__e_s
tress55423163tr__ess
tressels8367653tressels
trets55928023tr__ets
trevets10499973trevets
trews86118893tr__ews
treys85018213tr__eys
trials64319883tr_ials
tribals9610743tribals
tribes85119023tribe_s
triceps11267343triceps
trices84826333trice_s
triens65417543tr_iens
triers64321523tr_iers
tries55742813tr_ie_s
trifles103814823trifles
trijets14308263trijets
trikes105419493trike_s
trills64319853tr_ills
trimers94615143trimers
trines64132563trine_s
triodes84012503triode_s
triolets83410143triolets
triols66117803tr_iols
trioses75015653triose_s
tripes85324873tripe_s
triples94616873triples
tritely1039003tritely
trivets103911583trivets
troaks104410593tro_aks
trocars959023trocars
trochees132510183trochees
troches123715343troches
trochils1388583trochils
trocks123614633tro_cks
trode65322853trode__
troffers14125423troffers
trogons83410713trogons
trogs67022603tro__gs
troikas1135023troikas
troilus736403troilus
trois57226093tro__is
troke94821053troke__
troked114114583troke_d
troll54416533tro__ll
trolled84312263trolled
troller73913173troller
trollers83211203trollers
trolley10328753trolley
trolleys11315693trolleys
trolly94012353tro_lly
trommel11315363trommel_
trompes114111623trompes
tromps104911703tro_mps
tronas63816893tro_nas
trone55131863trone__
troopers10289423troopers
troops85712773tro_ops
trope75725803trope__
tropics113610653tropics
tropins93116303tropins
troths95414153tro_ths
trots56629943tro__ts
trotters83310233trotters
trotyl9236673trotyl_
trouble957703trouble
troubles1057183troubles
troughs11698673troughs
troupers10359423troupers
troupes94112843troupes
trousers83910623trousers
trouts66116623tro_uts
trove85221923trove__
trover95014663trove_r
trow78031423trow___
troweling1376363troweling
trowelled1344443trowelled
troweller1244563troweller
trowellers1343653trowellers
trowing113413703trowing
trowth1277883trow_th
troys86418613tro__ys
truces84916333truce_s
trues54925323tr_ue_s
trulls64110283tr_ulls
trunnels844513trunnels
tsores65113663tsore_s
tunnels7328723tunnels
twofers1364053twofers
urodele845963urodele
urodeles945563urodeles
vowel115515013_vowel_
vowers124317183_vowers
vrows116115263vrow__s
yodels104610073_yodels
yokels13488063_yokels
yowes114926373_yowe_s
yowls115715433_yow_ls

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 Filter1786911340270.1701051123.5
2DLD Change Limit1340274278.03316684.6
3Display Results4274270.1562737.2
 (SQL Overall)1786914278.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.