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

105 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
garroters105582(None) 
garroter956591garroter_
garrotes969381garrote_s
parroters1156771parroters
barraters1138042barraters
garotes8614572ga_rote_s
garotters1055042garotters
garrote8510112garrote__
garroted1056792garrote_d
garrottes1065492garrottes
garters84218252ga_r_ters
harrowers1555692harrowers
narraters946702narraters
parroter1058212parroter_
aborters1038573_aborters
arbiters1038853_arbiters
armorers10288973_armorers
arrayers11125853_arrayers
arresters948203_arresters
arrivers11137003_arrivers
balloters1157673balloters
barrater10310153barrater_
barrators1148393barrators
barretors1146243barretors
barriers104311893barr_iers
barristers1244733barristers
barters94223053ba_r_ters
borrowers1474033borrowers
burrowers1483503burrowers
carolers103314173ca_rolers
carriers103614203carr_iers
carrotier1146623carrotier_
carrotins11239963carrotins
carrots9714623carrot__s
carryovers1842513carryovers
carters95327263ca_r_ters
cavorters1434973cavorters
darters84017613da_r_ters
fagoters1234863fa_goters
farriers113610743farr_iers
ferreters1246253ferreters
furrowers1563503furrowers
gagsters10317083ga_gsters
gaiters83516543ga__iters
gallopers12136323gallopers
gamesters1236743gamesters
gammoners1444573gammoners
gangsters11205733gangsters
ganisters10248313ganisters
gaolers83511563ga__olers
garblers113810283ga_rblers
gardeners1136613gardeners
garglers10418263ga_rglers
garners83815993ga_r_ners
garote7717953ga_rote__
garoted9710133ga_rote_d
garotter965953garotter_
garottes978293ga_rottes
garreted1057523garrete_d
garrets84413623garr__ets
garrons82713463garro__ns
garroting1136953garroting
garrotte965693garrot_te
garrotted1164133garrotted
garter74420513ga_r_ter_
gasters85624303ga__sters
gaters74728643ga___ters
grafters12409193g_rafters
granters93614153g_ranters
graters85419743g__raters
greeters92610123g_reeters
grifters12389233g_rifters
gristers94013413g_risters
gritters94210633g_ritters
grocers103511253g__rocers
groomers11388483g_roomers
groovers12337123g_roovers
gropers104813853g__ropers
grouters95910093g_routers
growers113612723g__rowers
grunters9359043g_runters
harborers1446913harborers
harriers113712433harr_iers
harrower1446373harrower_
larrupers1142523larrupers
marketers1545993marketers
marrers93414313marr__ers
marriers103312473marr_iers
narrater838723narrater_
narrates8312763narrate_s
narrators947863narrators
narrower1145073narrower_
pardoners12208223pardoners
parriers103612913parr_iers
parrokets1543923parrokets
parroted1158853parrote_d
parrots9312743parrot__s
rioters73615523__rioters
rooters74522933__rooters
sorrowers1274763sorrowers
tarriers83411713tarr_iers
uprooters1164253uprooters
warpowers1744563warpowers
warranters1344543warranters
warreners1236203warreners

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411058.08018396.2
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.56220870.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.