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) 
barriers104311881barriers
carriers103614201carriers
farriers113610741farriers
harrier104417751harrier_
harries103525491harrie_s
hurriers11358891hurriers
marriers103312471marriers
parriers103612901parriers
tarriers83411711tarriers
arrivers11137002_arrivers
barrier94017732barrier_
carrier93619582carrier_
carries94328012carrie_s
charrier1378682charrier_
curriers103410752curriers
farrier103514882farrier_
farriery14295402farriery
furriers11369482furriers
gharries12318202gharrie_s
hagriders1443552hagriders
hairier103111052hairier_
hardier114721542hardier_
hardies114923232hardie_s
harmers124116592ha_rmers
harpers124916202ha_rpers
harpies123818312harpie_s
harried113815532harrie_d
harrowers1555682harrowers
hauliers1176712hauliers
herries104025072herrie_s
hurrier103412932hurrier_
hurries103919652hurrie_s
marrers93414312marr_ers
marrieds11288072marrieds
marrier93817522marrier_
marries93825282marrie_s
parrier93717652parrier_
parries93925842parrie_s
partiers103514242partiers
quarriers1845182quarriers
tarrier74323172tarrier_
tarries73324262tarrie_s
tarsiers8298532tarsiers
terriers84210812terriers
variers103712662va_riers
warriors1135362warriors
worriers11257812worriers
aerier64823153_aerier_
aeries64737783_aerie_s
airers64922313_air_ers
airier64619363_airier_
arbiters1038853_arbiters
archers124414573_archers
arguers8489023_arguers
ariels65119373_a_riels
armers85520273_a_rmers
armies85123693_armie_s
armigers1135703_armigers
arrayers11125853_arrayers
arrears738843_arrears
arris56824683_arri__s
arrises71617583_arrises
arriver10117793_arriver_
arrives101311513_arrives
artier63419733_artier_
barbers114317503ba_rbers
barbies114519593barbie_s
barkers134318513ba_rkers
barkier133814483barkier_
barmier114313043barmier_
barnier93213673barnier_
barraters1138033barraters
barrels94514363barr_els
barrens94414323barr_ens
barres84427543barr_e_s
barrets94917103barr_ets
barrios9310773barri_os
barristers1244723barristers
barters94223033ba_rters
berries94423553berrie_s
brasiers103710513brasiers
braziers19397193braziers
briers85319733__briers
buriers94017193_buriers
burrers93814493burr_ers
burrier93613543burrier_
cahiers123510673ca_hiers
carders104820353ca_rders
careers95218783ca_reers
carers85133953ca_r_ers
caries85147623ca_rie_s
carnies94123963carnie_s
carolers103314173carolers
carpers114521253ca_rpers
carrels95117303carr_els
carried103717153carrie_d
carrions10312443carrions
carters95327243ca_rters
carvers124817533ca_rvers
cashiers13318883cashiers
catbriers1344143catbriers
chargers144011313cha_rgers
charier124317903cha_rier_
charlies133414223charlie_s
charmers154211323cha_rmers
charriest1438253charriest
charters134115563cha_rters
cherries131812973cherrie_s
corries94026783corrie_s
couriers103213163couriers
criers83918583__criers
currier93316693currier_
curriery13326163curriery
curries93723163currie_s
dairies84217733dairie_s
dalliers93610613dalliers
darbies104216983darbie_s
darers75921873da_r_ers
darkies124015753darkie_s
darners83815773da_rners
darters84017603da_rters
decriers11299733decriers
derriere936043derriere
derrieres1044813derrieres
derries83124623derrie_s
dhurries1255583dhurrie_s
driers74516733__driers
durries83817353durrie_s
earlier72612743earlier_
earners74016453ea_rners
earrings9299623earrings
faeries104118993faerie_s
fairies103516043fairie_s
fanciers13358083fanciers
farcers124713443fa_rcers
farcies125317883farcie_s
farers95924053fa_r_ers
farmers124315263fa_rmers
farrieries1344343farrieries
ferries103521083ferrie_s
firrier103410123firrier_
friers94718933__friers
furrier103513643furrier_
furriery14395673furriery
furriners12316303furriners
gambiers13337073gambiers
garblers113810283garblers
garglers10418263garglers
garners83815983ga_rners
garrets84413623garr_ets
garroters1055813garroters
garters84218223ga_rters
gharris11306433gharri__s
graziers18387123graziers
gurries83515953gurrie_s
hackers164619043ha_ckers
hackies163418243hackie_s
hacklers173710303hacklers
haeres94017033haer_e_s
hafters134614333ha_fters
hagglers13326623hagglers
hagrider1334483hagrider_
hagrides1337623hagrides
hailers104017263ha_ilers
hairiest11612463hairiest
hairiness1238013hairiness
hairless1157413hairless
hairnets1195633hairnets
hairs86225173ha__i_rs
halers94926913ha__lers
halters104619803ha_lters
halvers133311423ha_lvers
hammers144216053ha_mmers
hammier143510653hammier_
hampers143616943ha_mpers
hamsters13710423hamsters
hanapers1346963hanapers
handers114224333ha_nders
handier113817443handier_
handlers124014143handlers
hangers113120813ha_ngers
hankers144218133ha_nkers
hankies143617763hankie_s
happier143312033happier_
harassers1246193harassers
harbingers1643943harbingers
harborers1446913harborers
harbors12412413ha_rbors
harbours1346903harbours
hardeners1338083hardeners
hardens113815023ha_rdens
harder105022403ha_rder_
hardiest123416333hardiest
hardiness132310353hardiness
hardness122411083hardness
hardwires1644643hardwires
hareems12428203ha_reems
harems115513823ha_r_ems
hares86255543ha_r_e_s
harkeners1636073harkeners
harkens144112863ha_rkens
harmer114719553ha_rmer_
harmines132715133harmines
harmins123716713harmi_ns
harmless1337403harmless
harness102413933ha_rness
harper115018403ha_rper_
harpings14379773harpings
harpins123615703harpi_ns
harpists1338093harpists
harridan12145123harridan
harridans13154563harridans
harrower1446363harrower_
harrows132611033harr_ows
harshens1437603harshens
harsher13310363harsher_
harslets1137833harslets
hastier103916623hastier_
hatchers163113173hatchers
haters94930393ha__ters
hatreds11307813hatr_eds
hatters104221523ha_tters
haulers104012443ha_ulers
haulier1059943haulier_
haunters11329533haunters
havers124721483ha__vers
haviors1347383ha_viors
hawkers174210333ha_wkers
hawkies173311243hawkie_s
hawsers13409483ha_wsers
hayers124415943ha__yers
hayricks2043763hayricks
hayrides1536883hayrides
haywires1744043haywires
hazarders2243023hazarders
hazers184615953ha__zers
hazier184712403ha_zier_
hearers104319783hear_ers
heartier1139093heartier_
hearties11315413heartie_s
henries102718283henrie_s
herbier1239593herbier_
herders113914123h_erders
herried113514453herrie_d
herrings12379523herrings
hirers94518063h_ir_ers
hoarders12307433hoarders
hoarier104211743hoarier_
hornier103012453hornier_
horrider1236523horrider_
horrors1078693horr_ors
horsier103013243horsier_
hosiers104212633h_osiers
hurdies114015663hurdie_s
hurdlers12337493hurdlers
hurlers103714323h_urlers
hurlies103315333hurlie_s
hurried113511043hurrie_d
hurters103413633h_urters
jerries143817513jerrie_s
kauries113613193kaurie_s
kerries113317913kerrie_s
lanciers10308543lanciers
larders83516943la_rders
lardier83518343lardier_
larkers113014513la_rkers
larkier113711523larkier_
larrupers1142523larrupers
lorries74518343lorrie_s
marblers12319233marblers
marchers153710813marchers
mariners103113863mariners
markers133516103ma_rkers
marlier92614773marlier_
marrer83716673marr_er_
married104715303marrie_d
merrier92612303merrier_
murries94118673murrie_s
narraters946693narraters
paniers94717333pa_niers
panniers10488853panniers
paraders113113113paraders
pardners11269193pardners
parers85530743pa_r_ers
paries84742513pa_rie_s
parkers133816873pa_rkers
parrels94713493parr_els
parried103615723parrie_d
parroters1156763parroters
parsers94118153pa_rsers
partier93520713partier_
parties93230863partie_s
partners102711133partners
partyers13277763partyers
perries93226603perrie_s
priers84521193__priers
quarrier1736843quarrier_
quarries1749943quarrie_s
quartiers1845183quartiers
queriers1736963queriers
ralliers84010833ralliers
rapiers95012873ra_piers
rarefiers1244023rarefiers
salliers83613333salliers
saltiers83411953saltiers
sarkier113413313sarkier_
sauciers1076733sauciers
sauries72821623saurie_s
scarrier10298453scarrier_
serries73925353serrie_s
sharers104720623sha_r_ers
sharkers154011053sha_rkers
sharpers133810943sha_rpers
sharpies13411223sharpie_s
sherries111812893sherrie_s
sorrier72313723sorrier_
sparrier10329143sparrier_
spurriers11245063spurriers
starrier8279463starrier_
talliers83711363talliers
tardier859719993tardier_
tardies84225863tardie_s
tarres64723043tarr_e_s
tarried83914133tarrie_d
tarriest83215003tarriest
tarriness9229243tarriness
tarsier74119253tarsier_
tartier74123263tartier_
terrier73414963terrier_
terries73425613terrie_s
triers64321523__triers
varier94619353va_rier_
varies94330873va_rie_s
verniers11227843verniers
warblers13319103warblers
warders113416813wa_rders
warier93722893wa_rier_
warmers124514293wa_rmers
warners103315563wa_rners
warpers123413583wa_rpers
warreners1236193warreners
warrens103810893warr_ens
warrior1045363warrior_
warslers11328073warslers
wartier103413913wartier_
wherries14179023wherrie_s
whirries14136693whirrie_s
worrier102311673worrier_
worries104117133worrie_s
yarders113211593ya_rders
yarners104312203ya_rners

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 Filter1786911461620.186960704.3
2DLD Change Limit1461623527.22020244.0
3Display Results3523520.1402514.3
 (SQL Overall)1786913527.54623680.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.