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

130 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
harrowed155628(None) 
arrowed1148131_arrowed
farrowed1545301farrowed
harrower1446371harrower
marrowed1445991marrowed
narrowed1235231narrowed
borrowed1465052borrowed
burrowed1444462burrowed
carromed1338572carromed
furrowed1563852furrowed
garroted1056792garroted
hallowed15179502hallowed
harbored1438642harbored
harried113815542harr_ied
harrow122610782harrow__
harrowers1555692harrowers
harrows132611042harrow_s
narrower1145072narrower
parroted1158852parroted
sorrowed1264842sorrowed
allowed111610083_allowed
aproned10311503_aproned
arbored103811603_arbored
armored102610473_armored
arrased8149873_arrased
arrayed11117163_arrayed
arrived11127353_arrived
arrow83414893_arrow__
arrowhead1641793_arrowhead
arrows92813493_arrow_s
arrowy12288283_arrow_y
avowed1335963_a_vowed
barraged1297703barraged
barred95725803barr__ed
barreled1137853barreled
barrow114512773barrow__
barrows123411693barrow_s
borrower1384843borrower
browed125216403__browed
burrower1374273burrower
carboyed1637183carboyed
caroled103717693ca_roled
caromed123713623ca_romed
carried103717153carr_ied
cartoned111312833cartoned
charioted1595873charioted
charred134614493charr__ed
cornrowed1543623cornrowed
corroded12147513corroded
crowed124717313__crowed
escrowed1434673escrowed
fallowed15127753fallowed
farrow12309983farrow__
farrows13259793farrow_s
furrower1464043furrower
garoted9710133ga_roted
garred85217413garr__ed
garreted1057523garreted
garrote8510113garrote_
garroter956593garroter
garrotes969383garrotes
garrotted1164133garrotted
hagrode1236453hagrode_
haired105117173hair__ed
halloaed121510153halloaed
halloed113314913hallo_ed
hallooed12168773hallooed
hallower14139823hallower
haloed104717603ha_lo_ed
hamboned1637003hamboned
harassed1237113harassed
harborer1348063harborer
harboured1544313harboured
hardened1338613hardened
hardwood16155743hardwood
hared95742183ha_r__ed
harked145422553ha_r_ked
harkened1637483harkened
harmed125218843ha_r_med
harped124418403ha_r_ped
harpooned1544323harpooned
harrier104417763harr_ier
harries103525503harr_ies
harrowing1646443harrowing
hatred104814333hatr__ed
hawed126025423ha___wed
herried113514473herr_ied
hollowed15157033hollowed
hurrahed1543473hurrahed
hurrayed1543053hurrayed
hurried113511043hurr_ied
jargoned1735233jargoned
jarred144613253jarr__ed
larruped1142873larruped
marooned1138573marooned
marred95421043marr__ed
married104715313marr_ied
marrow112812613marrow__
marrows122911833marrow_s
marrowy15236093marrow_y
mirrored1145773mirrored
narrated9310333narrated
narrow9269153narrow__
narrowest1244293narrowest
narrowly1442913narrowly
narrows10258853narrow_s
outrowed1239443outrowed
pardoned12189333pardoned
paroled104217633pa_roled
parred95024073parr__ed
parried103615723parr_ied
parroket1449213parroket
parroter1058213parroter
rowed94034323___rowed
sallowed12149033sallowed
shadowed1644483sha_dowed
shallowed1655093shallowed
sorrower1165053sorrower
strowed115312143_strowed
tallowed12157713tallowed
tarred74720283tarr__ed
tarried83914133tarr_ied
trowed104714653__trowed
varoomed1445293varoomed
wallowed15148173wallowed
wardrobed1662533wardrobed
warpower1645053warpower
warred104019853warr__ed
yarrow12287943yarrow__
yarrows13277863yarrow_s

Search took 10 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 Limit1461621308.56317069.0
3Display Results1301300.0462826.1
 (SQL Overall)1786911309.01519821.5
 
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.