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

172 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
harshens143760(None) 
harshen1339281harshen_
arshins10312572_arshins
darshans1286542darshans
hardens113815022har_dens
harkens144112862har_kens
harshened1644452harshened
harsher13310362harshe_r
harshest14310192harshest
harshness1545962harshness
harslets1137832harslets
hashes125024802ha_she_s
hastens106214812ha_stens
hausens1077632haus_ens
hoarsens11306032hoars_ens
marshes123615372marshe_s
sarsens7311392sars_ens
airsheds12274963airsheds
archers124414573_archers
arches114822043_arche_s
archons12311583_archons
arpens84814823_ar_pens
arseno6318913_ars_eno
arses55733873_ars_e_s
arshin9312173_arshin_
arsines73518843_arsines
arsons63917213_ars_ons
ashen87818673_a_shen_
ashes86230613_a_she_s
aspens85013353_a_spens
banshees13127863banshees
barchans1588683barchans
barrens94414323bar_rens
bashers124820833ba_shers
bashes115631393ba_she_s
brashes124518463brashe_s
burthens1335383burthens
careens94514703car_eens
carses85233653cars_e_s
cashes114729883ca_she_s
cashews15428603ca_shews
chastens13429183cha_stens
coarsens10348123coars_ens
crashers134013233crashers
crashes124618403crashe_s
darkens12409873dar_kens
darshan1167063darshan_
dasheens1244693da_sheens
dashers115016863da_shers
dashes106124983da_she_s
earshots1146623earshots
earthen1039253earthen_
fashes124524023fa_she_s
fastens105511753fa_stens
freshens14298313freshens
gardens93312093gar_dens
gashes105725153ga_she_s
girshes11248293girshe_s
gorhens1137183gor_hens
gurshes112210033gurshe_s
halogens1237363halogens
hamsters13710423hamsters
hansels104011663hans_els
hanses95022633hans_e_s
happens14359173ha_ppens
haptens124511343ha_ptens
harassers1246203harassers
harasses11311033harasse_s
harden105718533har_den_
hardhats1546833hardhats
hardhead1645883hardhead
hardheads1745773hardheads
hardies114923233hardie_s
hardness122411083hardness
hardpans1436453hardpans
hardships1845653hardships
hareems12428203har_eems
harems115513823har__ems
hares86255543har__e_s
harijans1845723harijans
harken135116343har_ken_
harmers124116593har_mers
harmines132715163harmines
harmins123716723har_mins
harmless1337403harmless
harness102413933har_ness
harpers124916203har_pers
harpies123818323harpie_s
harpins123615703har_pins
harpoons1337483harpoons
harriers113712433harriers
harries103525503harrie_s
harsh116418053harsh___
harshening1744173harshening
harshly1636273harsh_ly
harslet10315653harsle_t
hartshorns1652853hartshorns
hashed136021943ha_she_d
hasheesh1342593ha_sheesh
hashing145020163ha_shing
haslets102510863ha_slets
hassels104311023ha_ssels
hassles103411693hassle_s
hasten95718563ha_sten_
hastes95727073ha_ste_s
hatchels16368673hatchels
hatchers163113173hatchers
hatches153420273hatche_s
hatchets163310383hatchets
hausen9610383haus_en_
havens124514043ha__vens
hawsers13409483haws_ers
hawses125113993haws_e_s
hayseeds1543283hayseeds
hazelhens2441563hazelhens
hearkens15336693hear_kens
hearses104414543hears_e_s
heartens113010153hear_tens
heathens143210153heathens
hirsels10128353hirs_els
hirsles101510073hirsle_s
hoarsen10367993hoars_en_
horses94729353hors_e_s
horstes104516113horste_s
hushes124718593h_ushe_s
hyphens1836043h_yphens
kamseens1442823kamseens
kashers143914023ka_shers
khamseens1841193khamseens
larchen12479633larchen_
larches124416453larche_s
lashers104121833la_shers
lashes94831003la_she_s
lashins103915153la_shins
marchen143312073marchen_
marchers153710813marchers
marches143921173marche_s
marishes13512553marishe_s
marses84827113mars_e_s
marshals1337783marshals
martens93714953mar_tens
mashers124621053ma_shers
mashes115030003ma_she_s
oarsmen938093oarsmen_
parches143720003parche_s
parishes13314763parishe_s
parsecs11429923pars_ecs
parsers94118153pars_ers
parses85534703pars_e_s
parsleys1335093parsleys
parsons93516873pars_ons
pashes115828393pa_she_s
qurshes19228573qurshe_s
rashers104020913ra_shers
rashes95330153ra_she_s
sarsen6314233sars_en_
sarsnets836783sarsnets
sashes94728483sa_she_s
sharpens13377813shar_pens
tarsiers8298533tarsiers
thrashers1565313thrashers
thrashes1487653thrashe_s
trashers113013643trashers
trashes104119263trashe_s
wardens113711903war_dens
warrens103810893war_rens
warships1647553warships
warslers11328073warslers
warsles103413643warsle_s
washers134517523wa_shers
washes124425493wa_she_s
worsens104610263wors_ens

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.423422437.4
2DLD Change Limit1461621728.17017890.1
3Display Results1721720.0632730.2
 (SQL Overall)1786911728.65620643.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.