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 “trollers” 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
trollers8321121(None) 
rollers73117471_rollers
strollers937551strollers
tollers73217461t_ollers
trillers83613491trillers
troller73913171troller_
trolleys11315691trolleys
broilers103210092broilers
carollers1137702carollers
crullers1047302crullers
drillers9429722drillers
droller84110282droller_
drollery12314792drollery
enrollers976172enrollers
frillers11349872frillers
grillers93810812grillers
growlers12327092growlers
hollers103818232_hollers
knollers12255142knollers
krullers1234132krullers
lollers72713792_lollers
patrollers1244812patrollers
pollers93420022_pollers
prowlers13328932prowlers
rerollers9207122rerollers
rolfers104011812_rolfers
roller63919792_roller_
stroller848182stroller_
tellers73717602t_ellers
thrillers1244472thrillers
tillers73418742t_illers
toilers74116262t_oilers
toller63819442t_oller_
toolers74416502t_oolers
toolless836342toolless
tootlers8289502tootlers
trailers82912922trailers
trawlers113310202trawlers
triflers113110212triflers
triller74215892triller_
troffers14125432troffers
trolled84312262trolle_d
trolley10328752trolle_y
trollies8310232trollies
trollops1044812trollops
trolls64613942troll__s
troopers10289442troopers
trotters83310242trotters
troublers1135002troublers
troupers10359442troupers
trousers83910632trousers
trovers103713322tro_vers
trowelers12105262trowelers
trowellers1343662trowellers
trowsers11428002trowsers
arousers84810983arousers
ballers94421013_ballers
billers94720833_billers
boilers93417063_boilers
bolters94017803_bolters
boodlers113710743boodlers
bowlers123715783_bowlers
braillers1135553braillers
brawlers13408643brawlers
bridlers11359183bridlers
broiders114211193broiders
broiler92911753broiler_
brokers133111913bro_kers
brollies1039533brollies
bronzers19296983bronzers
brooders112610243brooders
brothers133410833brothers
browless1346653browless
browsers13449203browsers
callers94221963_callers
carolers103314173caro_lers
caroller1039203caroller_
chillers133710923chillers
cholers124215203cho_lers
coalers94419353_coalers
coilers93619903_coilers
collars93816573_collars
collets93517903_collets
colliers103613583_colliers
colters93522443_colters
controllers1344783controllers
coolers93522493_coolers
corulers1039773corulers
cradlers11309203cradlers
crawlers13309013crawlers
croakers14288523croakers
crofters13358903crofters
crooners103911393crooners
cropless1237793cropless
croppers143311483croppers
crosiers103312063crosiers
crossers103912703crossers
crowders14398813crowders
crowers124614903cro_wers
crowners133710753crowners
crozers184111083cro_zers
croziers19287003croziers
cruller968753cruller_
cullers93418853_cullers
diallers957773diallers
dollars83311023_dollars
doodlers10338843doodlers
drawlers12307313drawlers
driller84311883driller_
drolled93810223drolle_d
drolleries1145443drolleries
drollest937353drollest
drollness1043623drollness
drolls75312393droll__s
droners84114383dro_ners
droplets1136063droplets
droppers13318603droppers
drovers115212643dro_vers
drowners12428273drowners
duellers9268223duellers
dwellers12356083dwellers
enrollees974323enrollees
enroller867183enroller_
evolvers14264773evolvers
extollers1663853extollers
fallers103917993_fallers
fellers104117543_fellers
fillers104320213_fillers
folders113514393_folders
folles93820473_folle_s
footlers113910793footlers
foozlers20346073foozlers
fowlers133411203_fowlers
friller104111743friller_
frivollers1642073frivollers
froglets1235263froglets
frothers14279813frothers
frowners14377933frowners
fuellers11277983fuellers
fullers103817373_fullers
gaolers83511563gao_lers
gillers84216903_gillers
girolles935523girolle_s
golfers114410083_golfers
griller84513353griller_
grillery12355503grillery
grilles83715023grille_s
groaners9248503groaners
grocers103511253gro_cers
groomers11388483groomers
groovers12337123groovers
gropers104813853gro_pers
grossers94410973grossers
groupers11358643groupers
grousers93810733grousers
grouters95910083grouters
grovelers13305163grovelers
grovellers1443323grovellers
growers113612723gro_wers
growler11318973growler_
gruelers936173gruelers
gruellers1034183gruellers
hellers103619833_hellers
hillers103718733_hillers
holders113715903_holders
holler93520613_holler_
howlers133312353_howlers
hullers103616263_hullers
ironers74813553iro_ners
jolliers15357433_jolliers
jolters143711993_jolters
killers114215583_killers
knoller11285913knoller_
kruller1145153kruller_
logrollers1142223logrollers
loller63315283_loller_
lullers73213353_lullers
millers93621343_millers
moilers93615203_moilers
molders103315553_molders
molters93816973_molters
mullers93217303_mullers
oglers74313183__oglers
oilers64721193__oilers
patroller1145743patroller_
peoplers1237163peoplers
polders103617373_polders
polers84225643_po_lers
pollees93215333_pollees
pollens93713303_pollens
poller83921853_poller_
poolers94217423_poolers
probers113514583pro_bers
problems1434343problems
prodders1237463prodders
proffers16126593proffers
profilers14236293profilers
proggers12258163proggers
prolegs10379993pro_legs
proles84627203pro_le_s
proofers13118363proofers
propellers1455203propellers
propers113619033pro_pers
prosers94219643pro_sers
prospers123012263prospers
provers123817793pro_vers
prowler123310013prowler_
pullers93618483_pullers
quellers17237533quellers
railers74420663_railers
ralliers84010833_ralliers
reelers73520273_reelers
reliers75519213_reliers
reroller8258753reroller_
riflers103512193_riflers
rilles64725503_rille_s
rillets74216153_rillets
roamers93713463_roamers
roarers73812743_roarers
robbers112814163_robbers
robles85321693_roble_s
rockers133916553_rockers
rodless8310073_rodless
rogers74517913_ro_gers
roles56747983_ro_le_s
rolfer94412273_rolfer_
rolled74220243_rolle_d
rollovers1244093_rollovers
rolls55326233_roll__s
rompers113412243_rompers
roofers105013903_roofers
roomers95416413_roomers
roosers74217883_roosers
rooters74522933_rooters
ropers84325903_ro_pers
rosters73727543_rosters
rotters74421393_rotters
rousers75220143_rousers
routers74822873_routers
rovers95423523_ro_vers
rowers94924573_ro_wers
rozzers1535633_rozzers
rulers64317093_r_ulers
scolders11288993scolders
scowlers13257373scowlers
scullers103510483scullers
sellers73721323_sellers
shellers112812583shellers
sillers73822103_sillers
smellers10329773smellers
smolders11287193smolders
solders83517773_solders
solvers104414253_solvers
spallers102910733spallers
spellers102812763spellers
spillers103311703spillers
spoilers10238633spoilers
spoolers10349363spoolers
stollens835293stollens
strokers123910903stro_kers
strolled937823strolle_d
strolls739183stroll__s
stroppers1356713stroppers
stroyers11388923stro_yers
swillers11299113swillers
tacklers143010773tacklers
tailers73720183t_ailers
tailles72516473taille_s
tailless8239083tailless
tailleurs942803tailleurs
talers64628143t__alers
talkers113513213t_alkers
taller63721963t_aller_
talliers83711373talliers
tanglers92911973tanglers
tattlers8369693tattlers
telfers10299073t_elfers
teller63519823t_eller_
thalers106212263t_halers
tholes94919783tho_le_s
thowless1434613thowless
thriller1165553thriller_
throbbers1643173throbbers
throttlers1352483throttlers
throwers14106033thro_wers
ticklers14339303ticklers
tiddlers10288653tiddlers
tilers63523503t__ilers
tiller64222543t_iller_
tilters73315953t_ilters
tinglers93710593tinglers
tinklers12298183tinklers
tipplers12336353tipplers
tochers123413093t_ochers
toddlers10346963toddlers
toeless72612393t_oeless
togglers10276953togglers
toiler63918283t_oiler_
toiles63923513t_oile_s
toilets74112913t_oilets
tokers104818893t_o_kers
tolars64817943t_o_lars
toles55147133t_o_le_s
tollbars1045443t_ollbars
tolled73819033t_olle_d
tolls54728433t_oll__s
toners64128003t_o_ners
tongers84116013t_ongers
tonlets73212503t_onlets
tonners73816403t_onners
toolbars1044743toolbars
tooler63818613t_ooler_
tooters73818773t_ooters
tootler73511123tootler_
tootles72915603tootle_s
topers85025323t_o_pers
topless92511123t_opless
toppers113914603t_oppers
torquers17204303torquers
tossers74713503t_ossers
toters65026363t_o_ters
totters74618733t_otters
tourers73512743t_ourers
touters74018353t_outers
towers94423673t_o_wers
toyers95516333t_o_yers
toyless10268713t_oyless
tracers94917843tr_acers
trackers143512853trackers
traders84316953tr_aders
trailer73015393trailer_
trailless935963trailless
trainers83114643trainers
tramless1037503tramless
trampers123210393trampers
tramplers13305883tramplers
trappers123711043trappers
trashers113013643trashers
travelers12266773travelers
travellers1364663travellers
trawler104011903trawler_
trawleys14284383trawleys
treaders93311843treaders
treadlers1045893treadlers
treaters83615843treaters
trebles9311443treble_s
treeless839283treeless
trekkers1133803trekkers
trellis739873trell_is
tremblers1334483tremblers
trickers143812813trickers
triers64321523tr__iers
trifler103912153trifler_
trifles103814823trifle_s
triggers10257843triggers
trilled84116313trille_d
trills64319853trill__s
trimers94615143tr_imers
trimmers12288913trimmers
triolets83410143triolets
triples94616873triple_s
triplets103510263triplets
trippers123210163trippers
trocars959043tro_cars
trochars1377853trochars
trochees132510183trochees
troches123715343troche_s
trochlears1543143trochlears
trochleas1444713trochleas
troffer13125863troffer_
troilus736413troil_us
trokes104019263tro_ke_s
trolands936423trolands
troll54416533troll___
trolleybus155873trolleybus
trolleyed1342473trolleyed
trollied935893trollied
trolling93212493trolling
trollings10286693trollings
trollop944793troll_op
trollopy1343273trollopy
trolly94012363troll__y
trommels12254333trommels
trompes114111623trompe_s
trones65629283tro_ne_s
trooper94210363trooper_
tropes84824353tro_pe_s
trotter73312253trotter_
troubler1035293troubler_
troubles1057203trouble_s
trouncers1134803trouncers
trouper93811433trouper_
troupes94112853troupe_s
trouser73812473trouser_
trouvere1144073trouvere
trouveres1243773trouveres
trouveurs1241643trouveurs
trover95014663tro_ver_
troves94719113tro_ve_s
troweler11106063troweler_
troweller1244563troweller_
trowels10358363tro_wels
truckers14279013truckers
trucklers15295583trucklers
trudgers10256863trudgers
trulls64110283trull__s
trundlers10215003trundlers
trussers8348283trussers
trusters83112263trusters
trysters11298373trysters
tuilles72411923tuille_s
tulles63218893t_ulle_s
tumblers123110623tumblers
tummlers12295703tummlers
turtlers8258203turtlers
twirlers11274303twirlers
twofers1364053two_fers
volleys13316643_volleys
willers103517913_willers
wolfers13409633_wolfers
wolvers13349313_wolvers
woolers104214023_woolers
woollens1144093woollens
wrongers12327773wrongers
yellers103912953_yellers
yodlers11298923_yodlers
yowlers13328923_yowlers

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 Filter1786911461620.406440125.6
2DLD Change Limit1461624277.68619016.7
3Display Results4274270.1732468.2
 (SQL Overall)1786914278.26521620.2
 
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.