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

544 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
troller7391317(None) 
droller84110281droller
roller63919791_roller
stroller848171stroller
toller63819441t_oller
triller74215891triller
trolled84312261trolled
trollers83211211trollers
trolley10328751trolley
broiler92911752broiler
caroller1039202caroller
cruller968752cruller
driller84311882driller
drolled93810222drolled
drollery12314792drollery
enroller867182enroller
friller104111742friller
griller84513352griller
growler11318972growler
holler93520612_holler
knoller11285912knoller
kruller1145152kruller
loller63315282_loller
patroller1145742patroller
poller83921852_poller
prowler123310012prowler
reroller8258752reroller
rolfer94412272_rolfer
rolled74220242_rolled
rollers73117472_rollers
strolled937812strolled
strollers937542strollers
taller63721962t_aller
teller63519812t_eller
thriller1165552thriller
tiller64222542t_iller
toiler63918282t_oiler
tolled73819032t_olled
tollers73217462t_ollers
tooler63818612t_ooler
tootler73511122tootler
trailer73015392trailer
trawler104011902trawler
trifler103912152trifler
trilled84116312trilled
trillers83613492trillers
troffer13125862troffer
troll54416532troll__
trolleys11315692trolleys
trollied935892trollied
trollies8310232trollies
trollop944792trollop
trolls64613942troll_s
trolly94012362troll_y
trooper94210362trooper
trotter73312252trotter
troubler1035292troubler
trouper93811432trouper
trouser73812472trouser
trover95014662tro_ver
troweler11106062troweler
troweller1244562troweller
arouser74514423arouser
baller83825203_baller
biller84923483_biller
boiler84319273_boiler
bolder94820933_bolder
bolled94722653_bolled
bolter83920753_bolter
boodler103312003boodler
bowler114217313_bowler
brailler1036883brailler
brawler124310233brawler
bridler103811073bridler
broader103412613broader
broider103912973broider
broiled103811423broiled
broilers103210093broilers
broker124314243bro_ker
brollies1039533brollies
brolly114510853broll_y
bronzer18348493bronzer
brooder103811623brooder
brother123311333brother
browner124911643browner
browser124911143browser
caller85125483_caller
caroler93816753caro_ler
carolled1138833carolled
carollers1137703carollers
chiller124112183chiller
choler113717153cho_ler
coaler84121713_coaler
coiler84421593_coiler
colder95121853_colder
collar83816173_collar
collet84030363_collet
collier93618153_collier
colter84625093_colter
controller1245523controller
cooler84824713_cooler
coruler9311713coruler
cradler102910513cradler
crawler123510463crawler
croaker133010683croaker
crofter12299573crofter
crooker134111093crooker
crooner93714043crooner
cropper133312963cropper
crosier94116573crosier
crosser95015463crosser
crowder13389863crowder
crower114117563cro_wer
crowner124012603crowner
crozer175112843cro_zer
crozier18369933crozier
crueler939023crueler
crueller1056453crueller
crullers1047303crullers
culler84322253_culler
dialler848813dialler
dollar74110983_dollar
dolled83518073_dolled
doodler93310153doodler
drawler11338593drawler
drilled94711673drilled
drillers9429723drillers
droll65415403droll__
drollest937353drollest
drolls75312393droll_s
drolly105411673droll_y
droner74717673dro_ner
drooled9369203drooled
droolier936073droolier
droplet10312113droplet
dropper12329873dropper
drover104614593dro_ver
drowner11369803drowner
dueller8329833dueller
duller74017703_duller
dweller11297273dweller
enrolled967963enrolled
enrollee878343enrollee
enrollers976173enrollers
eviller1056673eviller
evolver13275803evolver
extoller1564173extoller
faller94621233_faller
feller94419553_feller
filler94623623_filler
folder104317543_folder
folles93820473_folles
footler104011873footler
foozler19397593foozler
fouler93614903_fouler
fowler123712583_fowler
frailer10319943frailer
frilled113911603frilled
frillers11349873frillers
frillier1136513frillier
frivoller1542433frivoller
froglet11310063froglet
fronter103611583fronter
frother133110153frother
frowner13429683frowner
fueller10279963fueller
fuller94220383_fuller
gaoler73913573gao_ler
giller74519733_giller
girolle835793girolle_
girolles935523girolles
golder84417603_golder
golfer104411183_golfer
grille74315743grille_
grilled94012833grilled
grillers93810813grillers
grillery12355503grillery
grilles83715023grilles
groaner82510133groaner
grocer94212143gro_cer
grodier939673grodier
groomer10399873groomer
groover11358543groover
groper94517253gro_per
grosser84313143grosser
grouper104210093grouper
grouser84513693grouser
grouter84412523grouter
groveler12305843groveler
groveller1354233groveller
grower104614933gro_wer
growled12278173growled
growlers12327093growlers
growlier1234883growlier
grueler837023grueler
grueller935333grueller
heller93322513_heller
hiller94421633_hiller
holder104619653_holder
holier94921623_holier
hollers103818233_hollers
howler123514313_howler
huller93919103_huller
iller54821293__iller
ironer64216453iro_ner
jollier142911003_jollier
jolter133513093_jolter
killer104917953_killer
knolled12296573knolled
knollers12255143knollers
kroner104612573kro_ner
krullers1234133krullers
logroller1042443logroller
lolled74315823_lolled
lollers72713793_lollers
luller63415483_luller
miller84625413_miller
moiler84017263_moiler
molder93819273_molder
molter84119423_molter
muller83820353_muller
nobler83713453_nobler
ogler65917443__ogler
oiler54628283__oiler
older65121173__older
outrolled1037433outrolled
patrolled1245713patrolled
patrollers1244813patrollers
peopler1138083peopler
polder94019253_polder
poler74431793_po_ler
polled94022003_polled
pollee83623273_pollee
pollen83416453_pollen
pollers93420023_pollers
pollex153711163_pollex
pooler83819843_pooler
prilled104713003prilled
prober104516073pro_ber
problem1335983problem
prodder1147953prodder
proffer15126933proffer
profiler13287643profiler
progger11319373progger
prole74527793pro_le_
proleg94612113pro_leg
proles84627203pro_les
proofer12149103proofer
propeller1346623propeller
proper104319953pro_per
proser84223463pro_ser
prosier93817483prosier
prosper114012193prosper
prouder10310383prouder
prover113819723pro_ver
prower114218123pro_wer
prowled13309913prowled
prowlers13328933prowlers
puller83820813_puller
queller16289293queller
railer64524933_railer
rallier73816273_rallier
realer63528593_realer
reeler63822573_reeler
relier65826183_relier
rerolled93010053rerolled
rerollers9207123rerollers
rifler94014263_rifler
rille55728733_rille_
rilled74525653_rilled
rilles64725503_rilles
rillet64828853_rillet
roamer84715163_roamer
roarer63914333_roarer
robber103916533_robber
roble75223023_roble_
robles85321693_robles
rocker124319573_rocker
roger64521413_ro_ger
roiled74320053_roiled
roilier7311523_roilier
role45851823_ro_le_
roles56747983_ro_les
rolfed104510523_rolfed
rolfers104011813_rolfers
roll46331653_roll__
rollover1144453_rollover
rolls55326233_roll_s
romper104213683_romper
roofer94415283_roofer
roomer84718633_roomer
rooser63921883_rooser
rooter64926033_rooter
roper75431913_ro_per
ropier84118803_ropier
rosier64221263_rosier
roster64329083_roster
rotter64325463_rotter
rouser65224083_rouser
router65025843_router
rover85527373_ro_ver
rower85430493_ro_wer
rozzer1437353_rozzer
ruler54923343_r_uler
rulier65016353_rulier
scolder103210343scolder
scowler12248193scowler
scrolled1137053scrolled
sculler99812153sculler
seller63824593_seller
sheller103515883sheller
shoaler102610083shoaler
shriller1136823shriller
siller64026063_siller
smaller93410333smaller
smeller94212783smeller
smolder10327753smolder
sneller73512843sneller
solder73921343_solder
solver94016703_solver
spaller92713473spaller
speller95415143speller
spiller92914333spiller
spoiler93310683spoiler
spooler93711383spooler
stiller73414293stiller
stollen747583stollen
stroker114113523stro_ker
stroll6311603stroll__
strolls739183stroll_s
stronger9349693stronger
stropper1247763stropper
stroyer103510783stro_yer
sweller103012463sweller
swiller103211663swiller
swollen1034263swollen
tackler134013323tackler
tailer63823733t_ailer
taille63116923taille_
tailles72516473tailles
tailleur843303tailleur
taler56034863t__aler
talker103916223t_alker
tallier72817213tallier
tangler83515073tangler
tattler73112213tattler
telfer9379893t_elfer
tellers73717593t_ellers
thaler94613103t_haler
thole85620843tho_le_
tholed105113873tho_led
tholes94919783tho_les
thralled1245803thralled
thrilled1235493thrilled
thrillers1244473thrillers
throbber1543203throbber
throttler1262863throttler
thrower1386993thro_wer
tickler133612653tickler
tiddler93110003tiddler
tiler56131023t__iler
tilled74722953t_illed
tillers73418743t_illers
tilter63417693t_ilter
tingler83613343tingler
tinkler113610543tinkler
tippler11348343tippler
tocher114014913t_ocher
toddler9379043toddler
toggler9399193toggler
toile54626493t_oile_
toiled74420323t_oiled
toilers74116263t_oilers
toiles63923513t_oiles
toilet66228093t_oilet
toker95924913t_o_ker
tolar55524113t_o_lar
tole46052903t_o_le_
toled65934923t_o_led
toles55147133t_o_les
toll45535263t_oll__
tollbar945453t_ollbar
tollmen935733t_ollmen
tolls54728433t_oll_s
toner55336243t_o_ner
tonger74719683t_onger
tonier65520713t_onier
tonlet62924703t_onlet
tonner64819203t_onner
toolbar944773toolbar
tooled74918903t_ooled
toolers74416503t_oolers
toolless836343toolless
tooter64420803t_ooter
tootle62613813tootle_
tootled83511043tootled
tootlers8289503tootlers
tootles72915603tootles
toper75231023t_o_per
topper103817603t_opper
torquer16205323torquer
tosser64215663t_osser
toter55932133t_o_ter
tother94117143t_other
totter65021463t_otter
tourer64115073t_ourer
touter63821033t_outer
tower85729203t_o_wer
toyer84521553t_o_yer
tracer84820233tr_acer
tracker133515173tracker
trader75218763tr_ader
trailed83415673trailed
trailers82912923trailers
trainer73316793trainer
tramper113812163tramper
trampler12278013trampler
trapper113912803trapper
trasher104416133trasher
traveler11328433traveler
traveller1266603traveller
trawled113411523trawled
trawlers113310203trawlers
trawley13317303trawley
treader84113833treader
treadler936863treadler
treater74219833treater
treble8311663treble_
trebled1038483trebled
trebles9311443trebles
trekker1034733trekker
trellis739873trellis
trembler1235363trembler
tricker134615523tricker
trier54328533tr__ier
trifle94012883trifle_
trifled113711963trifled
triflers113110213triflers
trifles103814823trifles
trigger9329163trigger
trill55122933trill__
trills64319853trill_s
trimer85717153tr_imer
trimmer113610833trimmer
triolet73219523triolet
triple84215923triple_
tripled104113833tripled
triples94616873triples
triplet94319213triplet
triplex16447803triplex
tripper113711923tripper
triter65120593tr_iter
troaked12438253troaked
trocar848773tro_car
trochar1257073trochar
troche113112513troche_
trochee122613883trochee
troches123715343troches
trochlea1345193trochlea
trochlear1443453trochlear
trocked144312243trocked
trodden934883trodden
trode65322853tro_de_
troffers14125433troffers
troilus736413troilus
troke94821053tro_ke_
troked114114583tro_ked
trokes104019263tro_kes
troland837543troland
trolleyed1342473trolleyed
trolling93212493trolling
trollops1044813trollops
trollopy1343273trollopy
trommel11315363trommel
trompe105611263trompe_
tromped124210293tromped
trompes114111623trompes
trone55131863tro_ne_
trones65629283tro_nes
trooped104010723trooped
troopers10289443troopers
trope75725803tro_pe_
tropes84824353tro_pes
trothed114010973trothed
trotted83711283trotted
trotters83310243trotters
trouble957713trouble_
troubled1134983troubled
troublers1135003troublers
troubles1057203troubles
trouncer1035443trouncer
troupe84812433troupe_
trouped103910983trouped
troupers10359443troupers
troupes94112853troupes
trousers83910633trousers
troutier8277153troutier
trouvere1144073trouvere
trouveur1141673trouveur
trove85221923tro_ve_
trovers103713323tro_vers
troves94719113tro_ves
trowed104714653tro_wed
trowel94211463tro_wel
troweled12106113troweled
trowelers12105263trowelers
trowelled1344443trowelled
trowellers1343663trowellers
trowels10358363trowels
trowsers11428003trowsers
trucker134010733trucker
truckler14297453truckler
trudger9338733trudger
truer54916643tr__uer
trull54012673trull__
trulls64110283trull_s
trundler9256153trundler
trusser74010263trusser
truster73114313truster
tryster10369513tryster
tuille63012643tuille_
tuilles72411923tuilles
tulle54019933t_ulle_
tulles63218893t_ulles
tumbler113412823tumbler
tummler11266613tummler
turtler72610323turtler
twilled11398033twilled
twirler10285203twirler
twofer1234353two_fer
unrolled9610413unrolled
volley12419743_volley
willer94021063_willer
wolfer12429983_wolfer
wolver12419713_wolver
wooler93615873_wooler
woolier103612353woolier
woolled1136643woolled
woollen1034723woollen
woollier1155433woollier
wronger11288823wronger
yeller94214513_yeller
yodler10389943_yodler
yowler123310043_yowler

Search took 7 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 Limit1340275446.17321711.8
3Display Results5445440.2032679.8
 (SQL Overall)1786915446.78226347.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.