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

256 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
trollies831023(None) 
brollies1039531brollies
trollied935891trollied
collies94326582_collies
dollies83620982_dollies
follies103618942_follies
hollies103420812_hollies
jollies143516272_jollies
lollies73116922_lollies
mollies93420232_mollies
rallies73823342_rallies
tallies73624602t_allies
tellies73820502t_ellies
trellis739872trelli_s
trellises947022trellises
trilbies1037692trilbies
troilites948432troilites
trolled84312262troll_ed
troller73913172troll_er
trollers83211212trollers
trolley10328752troll_ey
trolleys11315692trolleys
trolling93212492trolling
trollings10286692trollings
trollops1044812trollops
trolls64613942troll__s
trophies13413672trophies
trotlines939102trotlines
woollies1147412woollies
allies63827673__allies
atrophies14410093atrophies
ballies93725743_ballies
bellies94023723_bellies
billies93923503_billies
bollixes1747203_bollixes
brookies1459143brookies
brownies13189613brownies
brulyies1343423brulyies
brulzies1933983brulzies
bullies94121893_bullies
challies133915643challies
chillies134113483chillies
colies84837053_co_lies
collides113214473_collides
collie83621993_collie_
collied103316673_collied
collier93618153_collier
colliers103613583_colliers
collins93419833_collins
coolies93824963_coolies
cronies9622503cro_nies
croppies143111133croppies
crowdies1437553crowdies
cullies94419963_cullies
dallies84023193_dallies
dellies83622213_dellies
dhoolies1246963dhoolies
dillies84122163_dillies
doilies84017363_doilies
dollied93811143_dollied
doolies83920713_doolies
doylies114512573_doylies
drolled93810223droll_ed
droller84110283droll_er
drolleries1145443drolleries
drollest937353droll_est
drolling103510763drolling
drollness1043623drollness
drolls75312393droll__s
droolier936073droolier
drooliest1036343drooliest
dropsies1138693dropsies
droskies13186343droskies
enrollees974323enrollees
fellies104119743_fellies
fillies103420253_fillies
folkies143612253_folkies
folles93820473_foll_es
follis93113903_folli_s
frillier1136513frillier
frilliest1237113frilliest
frolics1236833fro_lics
gallies84122713_gallies
ghillies12408663ghillies
ghoulies1235393ghoulies
gillies84120963_gillies
girolles935523giroll_es
goalies8316023_goalies
googlies1086763googlies
grilles83715023grill_es
groupies1137523groupies
growlier1234883growlier
growliest1335583growliest
gullies84717313_gullies
holies94630033_ho_lies
holloes103818193_holloes
ironies7517423iro_nies
jellies143816533_jellies
jollied15349273_jollied
jollier142911003_jollier
jolliers15357433_jolliers
jolliest152910363_jolliest
kellies113516853_kellies
killies113318113_killies
molies84429513_mo_lies
mollie83517103_mollie_
nellies73418723_nellies
oldies7314423__oldies
orologies10311623orologies
polies84034583_po_lies
pollees93215333_pollees
pollices12410753_pollices
proclises1339543proclises
profiles133211233profiles
proles84627203pro_l_es
prolines102619693prolines
prossies101515223prossies
prosties101421193prosties
proxies163014933pro_xies
rallied83514083_rallied
rallier73816273_rallier
ralliers84010833_ralliers
rallyes10348553_rallyes
reflies104418533_reflies
relies65036423_r_elies
replies94521043_replies
rilles64725503_rill_es
roadies83317443_roadies
robles85321693_robl_es
roilier7311523_roilier
roiliest8312283_roiliest
roles56747983_ro_l_es
rolled74220243_roll_ed
roller63919793_roll_er
rollers73117473_rollers
rollick1335613_rollick
rollicks1444893_rollicks
rolling83620413_rolling
rollings9419953_rollings
rolls55326233_roll__s
roofies103014413_roofies
rookies113917103_rookies
roomies93017243_roomies
rowdies113112693_rowdies
sallies73227813_sallies
sillies73425083_sillies
stoolies8311083stoolies
strobiles1146953strobiles
strolled937813stroll_ed
stroller848173stroll_er
strollers937543strollers
strolling10238793strolling
strolls739183stroll__s
sullies74122233_sullies
tailles72516473taill_es
talkies113415733t_alkies
tallied83314753t_allied
tallier72817213t_allier
talliers83711373t_alliers
tallis63319963t_alli_s
tallises82713263t_allises
tallits73215993t_allits
tholes94919783tho_l_es
tillites8312833t_illites
toadies82914863t_oadies
tobies84521023t_o_bies
toddies93011993t_oddies
todies74223553t_o_dies
toffies133210213t_offies
toiles63923513t_oil_es
tolanes74216313t_olanes
toles55147133t_o_l_es
tollages92410193t_ollages
tolled73819033t_oll_ed
toller63819443t_oll_er
tollers73217463t_ollers
tolling83418563t_olling
tollmen935733t_ollmen
tolls54728433t_oll__s
toluides935553t_oluides
toluids835323t_oluids
tommies113812983t_ommies
toolless836343toolless
toonies73719883t_oonies
tootles72915603tootl_es
tootsies848613tootsies
toplines102412563t_oplines
tories65435883t_o_ries
towies93521193t_o_wies
towlines112610343t_owlines
townies103113623t_ownies
tramlines1139843tramlines
trannies8415013trannies
traplines11310373traplines
treaties8316983treaties
trebles9311443trebl_es
trellised1044653trellised
trendies9312213trendies
trevallies1343463trevallies
tries55742813tr___ies
trifles103814823trifl_es
trilled84116313trill_ed
triller74215893trill_er
trillers83613493trillers
trilling92815963trilling
trillion847973trillion
trillions947183trillions
trillium1046203trillium
trilliums1144333trilliums
trills64319853trill__s
trilogies1048173trilogies
triples94616873tripl_es
triplites1148283triplites
trochees132510183trochees
troches123715343tro_ches
trochils1388583trochils
troilism1047193troilism
troilisms1146413troilisms
troilite849543troilite
troilus736413troil_us
troiluses944553troiluses
trois57226093tro__i_s
trokes104019263tro__kes
trolands936423trolands
troll54416533troll___
trolleyed1342473trolleyed
trollop944793troll_op
trollopy1343273trollopy
trolly94012363troll__y
trollying1354053trollying
trompes114111623tro_mpes
trones65629283tro__nes
tropes84824353tro__pes
trophied1437643trophied
tropics113610653tro_pics
tropines102214923tropines
tropins93116313tro_pins
trotline8310023trotline
troubles1057203troubles
trounces1037063trounces
troupes94112853tro_upes
troutier8277153troutier
troutiest9127803troutiest
troves94719113tro__ves
trulls64110283trull__s
trusties82712853trusties
tuilles72411923tuill_es
tulles63218893t_ull_es
twoonies1155693twoonies
urologies1039533urologies
wallies103320743_wallies
wellies103719073_wellies
willies103920153_willies
woolies104117363_woolies
woollier1155433woollier
woolliest1235853woolliest

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.436409841.7
2DLD Change Limit1461622567.75018859.6
3Display Results2562560.1102327.3
 (SQL Overall)1786912568.29621539.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.