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

275 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
trolley1032875(None) 
trolled84312261trolled
troller73913171troller
trolleys11315691trolleys
trolly94012361troll_y
brolly114510852broll_y
drolled93810222drolled
droller84110282droller
drollery12314792drollery
drolly105411672droll_y
rolled74220242_rolled
roller63919792_roller
strolled937822strolled
stroller848182stroller
tolled73819032t_olled
toller63819442t_oller
trawley13317302trawley
trilled84116312trilled
triller74215892triller
troll54416532troll__
trollers83211212trollers
trolleyed1342472trolleyed
trollied935892trollied
trollies8310232trollies
trollop944792trollop
trollopy1343272trollopy
trolls64613942troll_s
volley12419742_volley
alley85721673__alley
bolled94722653_bolled
broiled103811423broiled
broiler92911753broiler
brollies1039533brollies
carolled1138833carolled
caroller1039203caroller
collet84030363_collet
colly104926773_coll_y
coolly114811393cooll_y
cruller968753cruller
dolled83518073_dolled
dolly96125203_doll_y
doyley13487283_doyley
drilled94711673drilled
driller84311883driller
droll65415403droll__
drollest937353drollest
drolls75312393droll_s
drooled9369203drooled
drooly104911073drool_y
droplet10312113droplet
enrolled967963enrolled
enrollee878343enrollee
enroller867183enroller
erosely1038083erosely
foley115222303_fo_ley
folles93820473_folles
folly115022603_foll_y
frilled113911603frilled
friller104111743friller
frilly124111443frill_y
froglet11310063froglet
galley104215453_galley
girolle835793girolle_
girolles935523girolles
golly95121103_goll_y
grille74315743grille_
grilled94012833grilled
griller84513353griller
grillery12355503grillery
grilles83715023grilles
growled12278173growled
growler11318973growler
growly13499173growl_y
gulley104213163_gulley
holey115626903_ho_ley
holler93520613_holler
holly114824433_holl_y
jolly154517513_joll_y
knolled12296573knolled
knoller11285913knoller
knolly13336133knoll_y
kruller1145153kruller
lolled74315823_lolled
loller63315283_loller
lolly85120663_loll_y
molly105222493_moll_y
mooley11311633_mooley
motley1139383_motley
mulley114013453_mulley
orally93113593orall_y
orology11319463orology
outrolled1037433outrolled
patrolled1245713patrolled
patroller1145743patroller
polled94022003_polled
pollee83623273_pollee
pollen83416453_pollen
poller83921853_poller
pollex153711163_pollex
prilled104713003prilled
problem1335983problem
prole74527793pro_le_
proleg94612113pro_leg
proles84627203pro_les
pronely12310253pronely
prowled13309913prowled
prowler123310013prowler
pulley113713403_pulley
rally84725903_rall_y
rallye95110163_rallye
rerolled93010053rerolled
reroller8258753reroller
ridley10169543_ridley
riley84420583_r_iley
rille55728733_rille_
rilled74525653_rilled
rilles64725503_rilles
rillet64828853_rillet
roble75223023_roble_
robles85321693_robles
roiled74320053_roiled
roily86121113_roil_y
role45851823_ro_le_
roles56747983_ro_les
rolfed104510523_rolfed
rolfer94412273_rolfer
roll46331653_roll__
rollers73117473_rollers
rolls55326233_roll_s
rollway1344653_rollway
ropey106021873_ro_pey
scrolled1137053scrolled
solely93714213_solely
stollen747593stollen
stroll6311603stroll__
strollers937553strollers
strolls739183stroll_s
swollen1034263swollen
tabooley1342993tabooley
taille63116923taille_
tailles72516473tailles
taller63721963t_aller
tally84526863t_all_y
teller63519823t_eller
telly84920823t_ell_y
thole85620843tho_le_
tholed105113873tho_led
tholes94919783tho_les
thralled1245803thralled
thrilled1235493thrilled
thriller1165553thriller
tilled74722953t_illed
tiller64222543t_iller
toile54626493t_oile_
toiled74420323t_oiled
toiler63918283t_oiler
toiles63923513t_oiles
toilet66228093t_oilet
tole46052903t_o_le_
toled65934923t_o_led
toles55147133t_o_les
toll45535263t_oll__
tollers73217463t_ollers
tollmen935733t_ollmen
tolls54728433t_oll_s
tollway1344793t_ollway
tomalley1343283tomalley
toney86027413t_o_ney
tonlet62924703t_onlet
tooled74918903t_ooled
tooler63818613t_ooler
toolless836343toolless
tootle62613813tootle_
tootled83511043tootled
tootler73511123tootler
tootles72915603tootles
trailed83415673trailed
trailer73015393trailer
trawled113411523trawled
trawler104011903trawler
trawleys14284383trawleys
treble8311663treble_
trebled1038483trebled
trebles9311443trebles
trebly1138973trebl_y
trellis739873trellis
trey77228793tr___ey
trifle94012883trifle_
trifled113711963trifled
trifler103912153trifler
trifles103814823trifles
trigly103810943trigl_y
trilby1144973tr_ilby
trill55122933trill__
trillers83613493trillers
trills64319853trill_s
trilogy1136013trilogy
trimly114410893triml_y
triolet73219523triolet
triple84215923triple_
tripled104113833tripled
triples94616873triples
triplet94319213triplet
triplex16447803triplex
triply114211023tripl_y
tritely1039003tritely
troaked12438253troaked
troche113112513troche_
trochee122613883trochee
troches123715343troches
trochlea1345193trochlea
trocked144312243trocked
trodden934883trodden
trode65322853tro_de_
troffer13125863troffer
troilus736413troilus
troke94821053tro_ke_
troked114114583tro_ked
trokes104019263tro_kes
troland837543troland
trolleybus155873trolleybus
trolleying1442553trolleying
trolling93212493trolling
trollops1044813trollops
trommel11315363trommel
trompe105611263trompe_
tromped124210293tromped
trompes114111623trompes
trone55131863tro_ne_
trones65629283tro_nes
trooped104010723trooped
trooper94210363trooper
trope75725803tro_pe_
tropes84824353tro_pes
trophy1438283tro_phy
trothed114010973trothed
trotted83711283trotted
trotter73312253trotter
trouble957713trouble_
troubled1134983troubled
troubler1035293troubler
troubles1057203troubles
troupe84812433troupe_
trouped103910983trouped
trouper93811433trouper
troupes94112853troupes
trouser73812473trouser
trouty95211793tro_uty
trove85221923tro_ve_
trover95014663tro_ver
troves94719113tro_ves
trowed104714653tro_wed
trowel94211463tro_wel
troweled12106113troweled
troweler11106063troweler
trowelled1344443trowelled
troweller1244563troweller
trowels10358363trowels
troy77429683tro___y
trull54012673trull__
trulls64110283trull_s
truly84111553tr_ul_y
tuille63012643tuille_
tuilles72411923tuilles
tulle54019933t_ulle_
tulles63218893t_ulles
twilled11398033twilled
unrolled9610413unrolled
urology11217583urology
valley124311603_valley
volleys13316643_volleys
wholly15366573wholl_y
woolled1136643woolled
woollen1034723woollen
woolly12408513wooll_y

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 Filter1786911340270.423422437.4
2DLD Change Limit1340272757.25018486.5
3Display Results2752750.0932957.0
 (SQL Overall)1786912757.76623009.4
 
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.