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

352 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
harriers11371243(None) 
barriers104311891barriers
carriers103614201carriers
farriers113610741farriers
harrier104417761harrier_
harries103525501harrie_s
hurriers11358891hurriers
marriers103312471marriers
parriers103612911parriers
tarriers83411711tarriers
arrivers11137002_arrivers
barrier94017752barrier_
carrier93619582carrier_
carries94328012carrie_s
charrier1378692charrier_
curriers103410752curriers
farrier103514892farrier_
farriery14295402farriery
furriers11369492furriers
gharries12318222gharrie_s
hagriders1443552hagriders
hairier103111052hairier_
hardier114721542hardier_
hardies114923232hardie_s
harmers124116592ha_rmers
harpers124916202ha_rpers
harpies123818322harpie_s
harried113815542harrie_d
harrowers1555692harrowers
hauliers1176712hauliers
herries104025082herrie_s
hurrier103412942hurrier_
hurries103919652hurrie_s
marrers93414312marr_ers
marrieds11288072marrieds
marrier93817522marrier_
marries93825282marrie_s
parrier93717652parrier_
parries93925852parrie_s
partiers103514252partiers
quarriers1845192quarriers
tarrier74323172tarrier_
tarries73324262tarrie_s
tarsiers8298532tarsiers
terriers84210822terriers
variers103712662va_riers
warriors1135362warriors
worriers11257812worriers
aerier64823163_aerier_
aeries64737783_aerie_s
airers64922313_air_ers
airier64619363_airier_
arbiters1038853_arbiters
archers124414573_archers
arguers8489033_arguers
ariels65119373_a_riels
armers85520273_a_rmers
armies85123693_armie_s
armigers1135703_armigers
arrayers11125853_arrayers
arrears738853_arrears
arris56824683_arri__s
arrises71617583_arrises
arriver10117793_arriver_
arrives101311513_arrives
artier63419733_artier_
barbers114317503ba_rbers
barbies114519593barbie_s
barkers134318513ba_rkers
barkier133814483barkier_
barmier114313043barmier_
barnier93213673barnier_
barraters1138043barraters
barrels94514363barr_els
barrens94414323barr_ens
barres84427553barr_e_s
barrets94917113barr_ets
barrios9310783barri_os
barristers1244733barristers
barters94223053ba_rters
berries94423553berrie_s
brasiers103710513brasiers
braziers19397193braziers
briers85319733__briers
buriers94017193_buriers
burrers93814493burr_ers
burrier93613553burrier_
cahiers123510673ca_hiers
carders104820353ca_rders
careers95218783ca_reers
carers85133963ca_r_ers
caries85147623ca_rie_s
carnies94123963carnie_s
carolers103314173carolers
carpers114521253ca_rpers
carrels95117303carr_els
carried103717153carrie_d
carrions10312453carrions
carters95327263ca_rters
carvers124817543ca_rvers
cashiers13318883cashiers
catbriers1344153catbriers
chargers144011323cha_rgers
charier124317903cha_rier_
charlies133414233charlie_s
charmers154211333cha_rmers
charriest1438263charriest
charters134115593cha_rters
cherries131812993cherrie_s
corries94026803corrie_s
couriers103213173couriers
criers83918583__criers
currier93316703currier_
curriery13326163curriery
curries93723163currie_s
dairies84217733dairie_s
dalliers93610623dalliers
darbies104216983darbie_s
darers75921873da_r_ers
darkies124015753darkie_s
darners83815773da_rners
darters84017613da_rters
decriers11299733decriers
derriere936043derriere
derrieres1044813derrieres
derries83124623derrie_s
dhurries1255583dhurrie_s
driers74516733__driers
durries83817353durrie_s
earlier72612743earlier_
earners74016453ea_rners
earrings9299633earrings
faeries104118993faerie_s
fairies103516043fairie_s
fanciers13358083fanciers
farcers124713443fa_rcers
farcies125317883farcie_s
farers95924053fa_r_ers
farmers124315263fa_rmers
farrieries1344353farrieries
ferries103521083ferrie_s
firrier103410133firrier_
friers94718933__friers
furrier103513663furrier_
furriery14395683furriery
furriners12316323furriners
gambiers13337073gambiers
garblers113810283garblers
garglers10418263garglers
garners83815993ga_rners
garrets84413623garr_ets
garroters1055823garroters
garters84218253ga_rters
gharris11306433gharri__s
graziers18387123graziers
gurries83515953gurrie_s
hackers164619043ha_ckers
hackies163418243hackie_s
hacklers173710303hacklers
haeres94017033haer_e_s
hafters134614333ha_fters
hagglers13326623hagglers
hagrider1334483hagrider_
hagrides1337623hagrides
hailers104017263ha_ilers
hairiest11612473hairiest
hairiness1238013hairiness
hairless1157413hairless
hairnets1195633hairnets
hairs86225173ha__i_rs
halers94926923ha__lers
halters104619803ha_lters
halvers133311423ha_lvers
hammers144216063ha_mmers
hammier143510653hammier_
hampers143616953ha_mpers
hamsters13710423hamsters
hanapers1346963hanapers
handers114224333ha_nders
handier113817443handier_
handlers124014143handlers
hangers113120813ha_ngers
hankers144218133ha_nkers
hankies143617763hankie_s
happier143312043happier_
harassers1246203harassers
harbingers1643953harbingers
harborers1446913harborers
harbors12412413ha_rbors
harbours1346923harbours
hardeners1338093hardeners
hardens113815023ha_rdens
harder105022403ha_rder_
hardiest123416343hardiest
hardiness132310373hardiness
hardness122411083hardness
hardwires1644643hardwires
hareems12428203ha_reems
harems115513823ha_r_ems
hares86255543ha_r_e_s
harkeners1636083harkeners
harkens144112863ha_rkens
harmer114719563ha_rmer_
harmines132715153harmines
harmins123716723harmi_ns
harmless1337403harmless
harness102413933ha_rness
harper115018403ha_rper_
harpings14379773harpings
harpins123615703harpi_ns
harpists1338103harpists
harridan12145123harridan
harridans13154563harridans
harrower1446373harrower_
harrows132611043harr_ows
harshens1437603harshens
harsher13310363harsher_
harslets1137833harslets
hastier103916623hastier_
hatchers163113173hatchers
haters94930403ha__ters
hatreds11307813hatr_eds
hatters104221523ha_tters
haulers104012443ha_ulers
haulier1059943haulier_
haunters11329543haunters
havers124721483ha__vers
haviors1347383ha_viors
hawkers174210333ha_wkers
hawkies173311243hawkie_s
hawsers13409483ha_wsers
hayers124415943ha__yers
hayricks2043763hayricks
hayrides1536883hayrides
haywires1744043haywires
hazarders2243023hazarders
hazers184615953ha__zers
hazier184712403ha_zier_
hearers104319783hear_ers
heartier1139103heartier_
hearties11315423heartie_s
henries102718283henrie_s
herbier1239593herbier_
herders113914123h_erders
herried113514473herrie_d
herrings12379533herrings
hirers94518063h_ir_ers
hoarders12307433hoarders
hoarier104211743hoarier_
hornier103012463hornier_
horrider1236533horrider_
horrors1078693horr_ors
horsier103013243horsier_
hosiers104212643h_osiers
hurdies114015663hurdie_s
hurdlers12337493hurdlers
hurlers103714323h_urlers
hurlies103315333hurlie_s
hurried113511043hurrie_d
hurters103413653h_urters
jerries143817513jerrie_s
kauries113613193kaurie_s
kerries113317913kerrie_s
lanciers10308543lanciers
larders83516943la_rders
lardier83518343lardier_
larkers113014513la_rkers
larkier113711523larkier_
larrupers1142523larrupers
lorries74518353lorrie_s
marblers12319233marblers
marchers153710813marchers
mariners103113873mariners
markers133516103ma_rkers
marlier92614783marlier_
marrer83716673marr_er_
married104715303marrie_d
merrier92612303merrier_
murries94118673murrie_s
narraters946703narraters
paniers94717333pa_niers
panniers10488853panniers
paraders113113123paraders
pardners11269203pardners
parers85530743pa_r_ers
paries84742523pa_rie_s
parkers133816873pa_rkers
parrels94713493parr_els
parried103615723parrie_d
parroters1156773parroters
parsers94118153pa_rsers
partier93520713partier_
parties93230873partie_s
partners102711143partners
partyers13277763partyers
perries93226603perrie_s
priers84521193__priers
quarrier1736853quarrier_
quarries1749953quarrie_s
quartiers1845193quartiers
queriers1736973queriers
ralliers84010843ralliers
rapiers95012873ra_piers
rarefiers1244023rarefiers
salliers83613353salliers
saltiers83411953saltiers
sarkier113413313sarkier_
sauciers1076733sauciers
sauries72821623saurie_s
scarrier10298453scarrier_
serries73925353serrie_s
sharers104720623sha_r_ers
sharkers154011053sha_rkers
sharpers133810943sha_rpers
sharpies13411233sharpie_s
sherries111812903sherrie_s
sorrier72313733sorrier_
sparrier10329143sparrier_
spurriers11245063spurriers
starrier8279463starrier_
talliers83711383talliers
tardier859719993tardier_
tardies84225863tardie_s
tarres64723043tarr_e_s
tarried83914133tarrie_d
tarriest83215003tarriest
tarriness9229253tarriness
tarsier74119253tarsier_
tartier74123263tartier_
terrier73414963terrier_
terries73425633terrie_s
triers64321523__triers
varier94619353va_rier_
varies94330873va_rie_s
verniers11227843verniers
warblers13319103warblers
warders113416813wa_rders
warier93722893wa_rier_
warmers124514293wa_rmers
warners103315563wa_rners
warpers123413583wa_rpers
warreners1236203warreners
warrens103810893warr_ens
warrior1045363warrior_
warslers11328073warslers
wartier103413913wartier_
wherries14179033wherrie_s
whirries14136703whirrie_s
worrier102311683worrier_
worries104117133worrie_s
yarders113211593ya_rders
yarners104312203ya_rners

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.420425454.8
2DLD Change Limit1461623527.61019206.6
3Display Results3523520.1402514.3
 (SQL Overall)1786913528.17021871.6
 
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.